NTSB investigations: Cessna 150G, 1991
15 cases on aircraft the registry lists as Cessna 150G. 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 |
|---|---|
| 1966 | 26 |
| 1967 | 154 |
| 1968 | 122 |
| 1969 | 114 |
| 1970 | 83 |
| 1971 | 78 |
| 1972 | 57 |
| 1973 | 47 |
| 1974 | 30 |
| 1975 | 41 |
| 1976 | 36 |
| 1977 | 22 |
| 1978 | 26 |
| 1979 | 22 |
| 1980 | 24 |
| 1981 | 12 |
| 1982 | 14 |
| 1983 | 15 |
| 1984 | 12 |
| 1985 | 14 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 10 |
| 1989 | 8 |
| 1990 | 16 |
| 1991 | 15 |
| 1992 | 11 |
| 1993 | 13 |
| 1994 | 6 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 3 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 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\") = 1991
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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") = 1991
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 LAX92LA066Accident · No injuriesLimited investigationFinal reportCessna 150G · Point Mugu, CAThe pilot's disregard of the available wind information. Contributing to this accident was a high tail wind.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.NTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.NTSB FTW91LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · San Angelo, TXThe pilot's failure to refuel the airplane which resulted in engine failure due to fuel exhaustion.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.NTSB FTW91LA059Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Decatur, TXThe instructor's inadequate supervision and the student's failure to relinguish controls.NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.NTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.NTSB MIA91LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greenwood, MSFailure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…NTSB NYC91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Mount Gilead, OHThe pilot's improper use of carburetor heat resulting in an engine failure due to carburetor ice and a subsequent off airport landing in unsuitable terrain.NTSB MIA91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150G · La Belle, FLTotal loss of engine power due to undetermined reasons.