NTSB investigations: Cessna 150H, 1995
6 cases on aircraft the registry lists as Cessna 150H. 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
| 1967 | 3 |
|---|---|
| 1968 | 99 |
| 1969 | 104 |
| 1970 | 93 |
| 1971 | 96 |
| 1972 | 59 |
| 1973 | 39 |
| 1974 | 37 |
| 1975 | 41 |
| 1976 | 18 |
| 1977 | 32 |
| 1978 | 24 |
| 1979 | 16 |
| 1980 | 21 |
| 1981 | 16 |
| 1982 | 14 |
| 1983 | 13 |
| 1984 | 13 |
| 1985 | 8 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 15 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 12 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 13 |
| 1997 | 7 |
| 1998 | 11 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 3 |
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 ('2071818'))
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 ('2071818'))
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 LAX96LA048Accident · 1 fatalLimited investigationFinal reportCessna 150H · Imperial, CAthe student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…NTSB FTW95LA318Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Muskogee, OKThe pilot's evasive manuever to take off with insufficient runway available for attaining takeoff airspeed. Factors which contributed to the accident were: the unauthorized use of the airplane, the pilot's anxiety, and the dark night.NTSB FTW95LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Rockport, TXThe loss of engine power due to a stuck exhaust valve. The lack of suitable terrain for the forced landing was a factor.NTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.NTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.NTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.