NTSB investigations: Cessna 150L, 1993
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
Latest 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\") = 1993
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") = 1993
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 ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.NTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.NTSB LAX94LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Van Nuys, CAthe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion is a factor in this accident.NTSB SEA93LA211Accident · No injuriesLimited investigationFinal reportCessna 150L · Silverton, ORClearance was not maintained. A factor to the accident was: poor in-flight planning/decision.NTSB LAX93LA346Accident · No injuriesLimited investigationFinal reportCessna 150L · Chemehuevi Valy, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB NYC93LA142Accident · No injuriesLimited investigationFinal reportCessna 152L · East Berne, NYthe pilot's inadequate preflight planning for a departure from a short field and his failure to attain a proper climb rate, resulting in an in-flight collision with a 5 foot pole located on rising terrain, 20 feet above the airport elevation.NTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.NTSB LAX93LA294Accident · No injuriesLimited investigationFinal reportCessna 150L · Hanford, CAThe student pilot's failure to maintain aircraft control. Factors related to this accident were the pilot's poorly planned approach, failure to maintain the proper glide path, delay in raising the flaps, and the improper use of the carburetor heat.NTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.NTSB FTW93LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Navasota, TXPartial power loss due to left magneto fluctuating due to loose coil. A factor was the lack of suitable terrain for the forced landingNTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.NTSB MIA93LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Myers, FLFailure of the pilot-in-command to perform in-flight fuel consumption calculations. The lack of suitable terrain for a forced landing was a factor.NTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.NTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.NTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.NTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.NTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.NTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswind