NTSB investigations: Cessna 150L, 1995
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\") = 1995
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") = 1995
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 LAX96LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Quartzite, AZthe pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.NTSB MIA96LA025Accident · No injuriesLimited investigationFinal reportCessna 150L · Lantana, FLThe failure of the pilot-in-command to use the checklist and to set the parking brakes prior to engine start.NTSB CHI96LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Wabash, INdeer that went onto the runway as the aircraft was landing. The light condition at dusk was a related factor.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB BFO96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dayton, OHthe student pilot's poor in-flight planning and decision making during the approach to landing/go around. Related factors are his inadequate compensation for crosswind wind conditions.NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB LAX95LA343Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kona, HIthe failure of the student pilot to properly execute a planned steep approach and long landing so as to avoid wake turbulence behind the preceding large aircraft.NTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.NTSB CHI95LA264Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Murphysboro, ILthe pilot's improper use of carburetor heat which led to a loss of power due to carburetor ice, and his failure to maintain airspeed during the forced landing. The carburetor icing conditions were a factor.NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.NTSB FTW95IA243Incident · No injuriesIncident investigationFinal reportCessna 150L · Levelland, TXThe failure of the pilot of the other aircraft to maintain clearance during a formation flight. A factor was the lack of experience in the type of operation.NTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.NTSB CHI95LA173Accident · Minor injuriesLimited investigationFinal reportCessna 150L · St. Charles, MOthe student pilot's inadvertent interference with flight controls which resulted in a stall. A factor associated with the accident was the student's excessive use of the elevator control.NTSB ATL95LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Canton, GAThe student pilot's failure to maintain directional control during a crosswind landing.NTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.NTSB FTW95FA102Accident · 2 fatalField investigationFinal reportCessna 150L · Needville, TXLoss of control at an altitude insufficient for recovery after one of the two pilots on board attempted an aerobatic maneuver.