NTSB investigations: Cessna 150G, 2003
7 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\") = 2003
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") = 2003
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 ATL04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kinston, NCThe pilot's failure to maintain aircraft control which resulted in the dragging of the right wing tip and the on ground collision with a roadway.NTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB LAX03LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Angwin, CAThe pilot's failure to maintain control of the airplane during an attempted go-around, which resulted in a hard landing. Also causal was the pilot's failure to maintain directional control.NTSB ATL03LA096Accident · No injuriesLimited investigationFinal reportCessna 150G · Morris, ALThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.