NTSB investigations: Cessna 150L, 2008
6 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\") = 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 ('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") = 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 ('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 CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.NTSB CHI08CA277Accident · No injuriesData collectionFinal reportCessna 150L · Wadsworth, OHThe lack of radio communication with the airplane and the inadequate visual lookout by the driver of the vehicle.NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB CHI08LA162Accident · No injuriesLimited investigationFinal reportCessna 150L · Summerville, SCA total loss of engine power for undetermined reasons.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB LAX08LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mesa, AZA partial loss of engine power for undetermined reasons.