NTSB investigations: Jacobs R755A series, TX
16 cases on aircraft whose registry engine model is Jacobs R755A series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 2 |
| 1989 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2013 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35006'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35006'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.NTSB CEN09CA246Accident · No injuriesData collectionFinal reportCessna 195 · Burnet, TXThe pilot's inadequate compensation for the gusting crosswinds during landing.NTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.NTSB FTW90LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195 · San Antonio, TXPilot's improper recovery from a bounced landing and subsequent stall of the aircraft.NTSB FTW71FRA01Accident · No injuriesClosedGrumman G-164 · Raywood, TXNTSB FTW70DRG51Accident · No injuriesClosedGrumman G-164 · Edcouch, TXNTSB FTW70F0245Accident · No injuriesClosedCessna 195 · Panola, TXNTSB FTW70D0162Accident · No injuriesClosedCessna 195 · San Antonio, TXNTSB FTW70D0019Accident · Minor injuriesClosedGrumman G-164 · Alvin, TXNTSB FTW68F0470Accident · No injuriesClosedCessna 195 · Dallas, TXNTSB FTW68F0078Accident · No injuriesClosedGrumman G-164 · Manvel, TXNTSB FTW67F0098Accident · No injuriesClosedCessna 195 · Odessa, TXNTSB FTW66F0071Accident · No injuriesClosedGrumman G-164 · Winters, TXNTSB FTW65F0031Accident · No injuriesClosedGrumman G-164 · Edcouch, TXNTSB UNK65X0471Accident · No injuriesClosedCessna 195 · Del Rio, TXNTSB UNK64X2605Accident · No injuriesClosedCessna 195 · Ft Worth, TX