NTSB investigations: Jacobs R755B series, TX
14 cases on aircraft whose registry engine model is Jacobs R755B 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 | 1 |
|---|---|
| 1968 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1976 | 2 |
| 1981 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2016 | 1 |
| 2026 | 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 ('35007'))
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 ('35007'))
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 CEN26LA145Accident · No injuriesClass 4 · LimitedFinal reportClassic Waco YMF · Galveston, TXThe biplane pilot’s failure to maintain an adequate visual lookout while taxiing, which included the failure to perform S-turns to compensate for limited forward visibility.NTSB CEN17LA032Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Ingleside, TXThe pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.NTSB FTW01LA105Accident · No injuriesLimited investigationFinal reportCessna 195B · Conroe, TXthe pilot's failure to compensate for the wind conditions during takeoff, which resulted in a ground loop.NTSB FTW99LA156Accident · No injuriesLimited investigationFinal reportCessna 195 · Conroe, TXThe fatigue fracture of the left main landing gear spring at the clamping mechanism, as a result of fretting.NTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.NTSB FTW85LA160Accident · No injuriesLimited investigationFinal reportCessna 195B · Bay City, TXCessna exhaust stack failed at weld. Hot exhaust burned through magnrto p leads and eng failed. During forced landing on a narrow farm road with a quartering tailwind. The acft drifted off the side of the road during the landing roll and nosed over.NTSB FTW81FQG45Accident · No injuriesClosedCessna 195B · Lubbock, TXNTSB FTW76FRG46Accident · Minor injuriesClosedCessna 195 · New Braunfels, TXNTSB FTW76DQG45Accident · No injuriesClosedCessna 195B · Midland, TXNTSB FTW74FRG82Accident · Minor injuriesClosedCessna 195 · San Antonio, TXNTSB FTW72FRG05Accident · No injuriesClosedCessna 195 · San Antonio, TXNTSB FTW71FRJ36Accident · No injuriesClosedCessna 195B · Mt.Enterprise, TXNTSB FTW68D0498Accident · No injuriesClosedGrumman G-164 · El Campo, TXNTSB UNK64X3723Accident · No injuriesClosedCessna 195 · Austin, TX