NTSB investigations: Cessna 150L, 2009
9 cases on aircraft the registry lists as Cessna 150L. 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 | 35 |
| 1972 | 56 |
| 1973 | 116 |
| 1974 | 153 |
| 1975 | 123 |
| 1976 | 104 |
| 1977 | 95 |
| 1978 | 83 |
| 1979 | 54 |
| 1980 | 59 |
| 1981 | 27 |
| 1982 | 34 |
| 1983 | 28 |
| 1984 | 17 |
| 1985 | 26 |
| 1986 | 27 |
| 1987 | 27 |
| 1988 | 19 |
| 1989 | 28 |
| 1990 | 35 |
| 1991 | 29 |
| 1992 | 29 |
| 1993 | 18 |
| 1994 | 21 |
| 1995 | 18 |
| 1996 | 18 |
| 1997 | 11 |
| 1998 | 21 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 16 |
| 2002 | 7 |
| 2003 | 8 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 9 |
| 2007 | 10 |
| 2008 | 6 |
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 8 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826'))
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 year(c."eventDate") = 2009
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826'))
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 ERA10LA084Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Hillsboro Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA10CA058Accident · Serious injuriesData collectionFinal reportCessna 150 · York, PAThe pilot's inadvertent encounter with a rotating propeller.NTSB CEN10CA048Accident · No injuriesData collectionFinal reportCessna 150L · Galion, OHThe student pilot's failure to maintain directional control.NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…NTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.NTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.NTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.