NTSB investigations: Cessna 150G, 1992
11 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\") = 1992
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") = 1992
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 ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB NYC93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lincoln, PAThe pilot's premature liftoff and delay in aborting the takeoff.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB LAX92LA366Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Fresno, CAThe loss of engine power due to carburetor icing and the failure of the pilot to use carburetor heat.NTSB ANC92LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Black River, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude to clear the terrain. Contributing to the accident were the pilot's lack of familiarity with the geographic area, and his lack of total experience in the type…NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.NTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB LAX92LA178Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Galt, CAThe pilot's poor in-flight decision by selecting an improper cruise altitude. Contributing to this accident was the pilot's fatigue due to lack of sleep.NTSB ANC92LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · Juneau, AKThe pilot failed to maintain directional control during the landing roll.NTSB LAX92LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Sacramento, CAThe failure of the CFI to properly use carburetor heat in conditions conducive to the formation of carburetor ice. Factors in this accident were: 1) weather conditions conducive to carburetor icing and 2) the lack of suitable terrain to complete the forced…