NTSB investigations: Cessna 150C, TX
16 cases on aircraft the registry lists as Cessna 150C. 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
| 1965 | 4 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1988 | 1 |
| 1993 | 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.aircraft_model_code IN ('2071808'))
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.aircraft_model_code IN ('2071808'))
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 FTW93LA112Accident · No injuriesLimited investigationFinal reportCessna 150C · El Paso, TXThe fuel exhaustion induced power loss and the failure of the pilot to refuel. A factor was the lack of suitable terrain.NTSB FTW88LA079Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · La Porte, TXA pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during…NTSB FTW80FPA15Accident · No injuriesClosedCessna 150 · Plano, TXNTSB FTW76FPD26Accident · No injuriesClosedCessna 150 · Eastland, TXNTSB FTW76FPD06Accident · No injuriesClosedCessna 150 · Ft Worth, TXNTSB FTW74AF088Accident · 1 fatalClosedCessna 150G · San Antonio, TXNTSB FTW73DPA29Accident · No injuriesClosedCessna 150 · Dallas, TXNTSB FTW73FRA09Accident · No injuriesClosedCessna 150G · Friendswood, TXNTSB FTW69F0486Accident · No injuriesClosedCessna 150 · Woodrow, TXNTSB FTW68D0026Accident · No injuriesClosedCessna 150 · Fort Worth, TXNTSB FTW66D0701Accident · No injuriesClosedCessna 150C · Ben Wheeler, TXNTSB FTW66F0543Accident · No injuriesClosedCessna 150C · Spade, TXNTSB FTW66F0325Accident · No injuriesClosedCessna 150 · Genoa, TXNTSB FTW66F0111Accident · No injuriesClosedCessna 150 · Pearland, TXNTSB FTW66F0106Accident · Minor injuriesClosedCessna 150C · Gilmer, TXNTSB UNK65X1298Incident · No injuriesClosedCessna 182B · Mineral Wells, TX