NTSB investigations: Cessna 150L, 1996
18 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\") = 1996
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") = 1996
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 CHI96LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · Wonder Lake, ILa blocked exhaust pipe as a result of an inadequate weld repair to the muffler.NTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.NTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.NTSB IAD96LA122Accident · 1 fatalLimited investigationFinal reportCessna 150L · Philippi, WVthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from trees, while maneuvering at low altitude. Intentional maneuvering at low altitude was a…NTSB CHI96LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Versailles, MOthe student pilot's failure to maintain airplane control during a go-around.NTSB IAD96LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Vincent, OHthe instructor's inadequate supervision by allowing the student and himself to become lost, his inadequate inflight planning/decision by failing to ensure the airplane was safely landed before fuel was exhausted, and his selection of unsuitable terrain for a…NTSB LAX96LA265Accident · Minor injuriesLimited investigationFinal reportCessna 150L · California City, CAThe pilot's selection of an inadequate cruise altitude in an area of rising terrain and his failure to consider the effect of the high density altitude on the climb capability of the aircraft.NTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.NTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB CHI96LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Charlotte, MIthe pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.NTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…NTSB LAX96LA151Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAA loss of engine power due to carburetor ice and the student's failure to use carburetor heat. The carburetor icing (weather) condition was a related factor.NTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.NTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.NTSB ATL96LA034Accident · No injuriesLimited investigationFinal reportCessna 150L · Sun City, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion. Darkness was a related factor.NTSB LAX96FA094Accident · 2 fatalField investigationFinal reportCessna 150 · Suisun, CAthe pilot's continued flight into known adverse weather conditions which eventually led to a loss of control due to spatial disorientation. Factors in the accident were: the pilot's inadequate preflight planning, his impairment due to medication, the foggy…