NTSB investigations: Cessna 150G, 2012
5 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\") = 2012
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") = 2012
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 ERA12LA574Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Corinth, MSThe improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…NTSB WPR12CA370Accident · Minor injuriesData collectionFinal reportCessna 150G · Madera, CAThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB ANC12CA045Accident · No injuriesData collectionFinal reportCessna 150G · Ketchikan, AKThe pilot’s decision to take off with a quartering tailwind, which resulted in a loss of control.NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…NTSB ERA12FA143Accident · Serious injuriesField investigationFinal reportCessna 150G · Fitchburg, MAA partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.