NTSB investigations: Cessna 150K, OH
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
| 1970 | 2 |
|---|---|
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1987 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2003 | 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\" = 'OH' 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" = 'OH' 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 NYC04LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Wooster, OHThe inadequate visual lookout of the student pilot of the Cessna 150M, which resulted in an on-ground collision with a Cessna 150K that was taking off.NTSB NYC02LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Seaman, OHThe pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.NTSB BFO96LA029Accident · 1 fatalLimited investigationFinal reportCessna 150K · Seville, OHpilot suicide (intentional in-flight collision with terrain).NTSB ATL87LA215Accident · No injuriesLimited investigationFinal reportCessna 150K · New Carlisle, OHDuring a takeoff attempt, the student retarded the throttle shortly after liftoff. This flt was the student plts second flight and the first flight with this instructor. The student was instructed to follow along on the flight controls. This was the first…NTSB CHI74FEI44Accident · No injuriesClosedCessna 150K · Louisville, OHNTSB CHI74DEI41Accident · No injuriesClosedCessna 150K · Elyria, OHNTSB CHI73FEG15Accident · No injuriesClosedCessna 150K · Vandalia, OHNTSB CHI71DEI60Accident · No injuriesClosedCessna 150 · Kellys Isle, OHNTSB CHI71DEG23Accident · No injuriesClosedCessna 150 · W Carrollton, OHNTSB CHI71DGG12Accident · No injuriesClosedCessna 150K · Columbus, OHNTSB CHI71DGA06Accident · No injuriesClosedCessna 150 · Harrison, OH