NTSB investigations: Cessna 150H, CO
19 cases on aircraft the registry lists as Cessna 150H. 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
| 1968 | 3 |
|---|---|
| 1969 | 1 |
| 1970 | 4 |
| 1971 | 2 |
| 1972 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2004 | 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 ('2071818'))
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 ('2071818'))
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 DEN04FA064Accident · Minor injuriesField investigationFinal reportCessna 150H · Boulder, COthe failed magneto and the lack of suitable terrain (lake) for a forced landing.NTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.NTSB DEN91FA034Accident · 1 fatalField investigationFinal reportCessna 150H · Mancos, COFailure of the student pilot to follow procedures and directives by continuing the flight at night and subsequently encountering adverse weather conditions. Factors related to the accident were: darkness, the student's lack of experience, adverse weather…NTSB DEN80FTE16Accident · Minor injuriesClosedCessna 150 · Paonia, CONTSB DEN78FTE67Accident · Minor injuriesClosedCessna 150H · Montrose, CONTSB DEN78DTE09Accident · No injuriesClosedCessna 150H · Durango, CONTSB DEN76DTE12Accident · No injuriesClosedCessna 150 · Boulder, CONTSB DEN75AD043Accident · 2 fatalClosedCessna 150H · Lamar, CONTSB DEN72AD050Accident · 2 fatalClosedCessna 150 · Kersey, CONTSB DEN72DTE29Accident · No injuriesClosedCessna 150H · Aurora, CONTSB DEN71FXD45Accident · No injuriesClosedCessna 150 · Aurora, CONTSB DEN71FXD16Accident · No injuriesClosedCessna 150H · Fort Collins, CONTSB DEN71DXD09Accident · No injuriesClosedCessna 150 · Sterling, CONTSB DEN70DXD29Accident · No injuriesClosedCessna 150 · Sterling, CONTSB DEN70DXD05Accident · No injuriesClosedCessna 150H · Englewood, CONTSB DEN69F0181Accident · Minor injuriesClosedCessna 150 · Longmont, CONTSB DEN69D0019Accident · Minor injuriesClosedCessna 150 · Yuma, CONTSB DEN68D0261Accident · No injuriesClosedCessna 150H · Cheraw, CONTSB DEN68D0236Accident · No injuriesClosedCessna 150 · Greeley, CO