NTSB investigations: Cessna 150H, 2002
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\") = 2002
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") = 2002
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 CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…NTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.NTSB CHI02CA191Accident · No injuriesData collectionFinal reportCessna 150H · Mecosta, MIThe airplane encountered unsuitable terrain and the pilot applied excessive braking during the aborted takeoff. A factor contributing to the accident was the sandy terrain.NTSB NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty winds