NTSB investigations: Cessna 150J, 2004
5 cases on aircraft the registry lists as Cessna 150J. 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
| 1966 | 1 |
|---|---|
| 1968 | 6 |
| 1969 | 55 |
| 1970 | 101 |
| 1971 | 72 |
| 1972 | 72 |
| 1973 | 52 |
| 1974 | 52 |
| 1975 | 30 |
| 1976 | 47 |
| 1977 | 29 |
| 1978 | 27 |
| 1979 | 25 |
| 1980 | 11 |
| 1981 | 19 |
| 1982 | 13 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 10 |
| 1987 | 15 |
| 1988 | 24 |
| 1989 | 10 |
| 1990 | 18 |
| 1991 | 19 |
| 1992 | 7 |
| 1993 | 15 |
| 1994 | 11 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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\") = 2004
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071820'))
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") = 2004
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071820'))
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 LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB FTW04LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lake Dallas, TXThe pilot's failure to maintain proper airspeed for flight resulting in a stall/spin during the forced landing. A contributing factors was the loss of engine power for undetermined reasons.NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB SEA04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Longview, WAFuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.