NTSB investigations: Cessna 150K, CO
11 cases on aircraft the registry lists as Cessna 150K. 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
| 1971 | 3 |
|---|---|
| 1974 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 2014 | 1 |
| 2020 | 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 ('2071822'))
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 ('2071822'))
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 CEN21LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Peyton, COThe student pilot did not maintain directional control of the airplane while landing. Contributing to the accident was the pilot’s diverted attention to the incorrect flap setting.NTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.NTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…NTSB DEN87LA246Accident · No injuriesLimited investigationFinal reportCessna 150K · Aurora, COThe student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.…NTSB DEN79DTE60Accident · No injuriesClosedCessna 150 · La Jara, CONTSB DEN79FTE23Accident · Minor injuriesClosedCessna 150K · Aurora, CONTSB DEN78DTE16Accident · No injuriesClosedCessna 150K · Longmont, CONTSB DEN75DTE38Accident · No injuriesClosedCessna 150 · Greeley, CONTSB DEN72DTE12Accident · No injuriesClosedCessna 150 · Englewood, CONTSB DEN71DXD65Accident · No injuriesClosedCessna 150 · Englewood, CONTSB DEN71DXD64Accident · No injuriesClosedCessna 150 · Englewood, CO