NTSB investigations: Cessna 150M, 2008
9 cases on aircraft the registry lists as Cessna 150M. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 6 |
| 1975 | 43 |
| 1976 | 72 |
| 1977 | 123 |
| 1978 | 104 |
| 1979 | 84 |
| 1980 | 57 |
| 1981 | 48 |
| 1982 | 53 |
| 1983 | 40 |
| 1984 | 40 |
| 1985 | 28 |
| 1986 | 31 |
| 1987 | 38 |
| 1988 | 32 |
| 1989 | 39 |
| 1990 | 34 |
| 1991 | 27 |
| 1992 | 26 |
| 1993 | 30 |
| 1994 | 32 |
| 1995 | 27 |
| 1996 | 26 |
| 1997 | 16 |
| 1998 | 22 |
| 1999 | 31 |
| 2000 | 17 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 12 |
| 2008 | 9 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 11 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 2008
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
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") = 2008
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
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 CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB SEA08CA143Accident · Minor injuriesData collectionFinal reportCessna 150M · Cove, ORThe pilot's failure to maintain clearance with terrain during a go-around.NTSB CHI08LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Palestine, ILThe loss of engine power due to carburetor icing. Contributing to the accident were the pilot's decision to conduct a low-power spiraling descent operation during conditions conducive to carburetor icing, and the weather that was conducive to carburetor icing.NTSB DFW08CA083Accident · No injuriesData collectionFinal reportCessna 150 · Idabell, OKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident are high and gusting winds.NTSB LAX08FA049Accident · 5 fatalField investigationFinal reportCessna 172N · Corona, CAThe failure of both pilots to see and avoid the other airplane.