NTSB investigations: Cessna 150, CO
14 cases on aircraft the registry lists as Cessna 150. 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 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 4 |
| 1968 | 1 |
| 1969 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1989 | 1 |
| 1992 | 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\" = 'CO' 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 ('2071802'))
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" = 'CO' 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 ('2071802'))
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 DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.NTSB DEN89LA207Accident · No injuriesLimited investigationFinal reportCessna C-150 · Platteville, COPilot's failure to compensate for the wind conditions and his failure to maintain directional control during the landing roll. Contributing to the accident was the gusting crosswind.NTSB DEN76FTE89Accident · No injuriesClosedCessna 150 · Hanover, CONTSB DEN74DTE11Accident · No injuriesClosedCessna 150 · Sterling, CONTSB DEN70D0162Accident · Minor injuriesClosedCessna 150 · Hugo, CONTSB DEN68D0235Accident · Minor injuriesClosedCessna 150 · Meeker, CONTSB DEN67F0134Accident · No injuriesClosedCessna 150 · Denver, CONTSB DEN67D0149Accident · No injuriesClosedCessna 150 · Artesia, CONTSB DEN67D0009Accident · No injuriesClosedCessna 150 · Meeker, CONTSB DEN66D0301Accident · No injuriesClosedCessna 150 · Hotchkiss, CONTSB DEN65A0081Accident · 1 fatalClosedCessna 150D · Byers, CONTSB UNK65X0414Accident · 2 fatalClosedCessna 150 · Fort Collins, CONTSB UNK64X3452Accident · No injuriesClosedCessna 150 · Denver, CONTSB UNK64X0148Accident · No injuriesClosedCessna 150 · Bennett, CO