NTSB investigations: Cessna 150D, 1982
4 cases on aircraft the registry lists as Cessna 150D. 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 | 29 |
|---|---|
| 1965 | 51 |
| 1966 | 41 |
| 1967 | 21 |
| 1968 | 24 |
| 1969 | 15 |
| 1970 | 13 |
| 1971 | 7 |
| 1972 | 11 |
| 1973 | 5 |
| 1974 | 4 |
| 1975 | 5 |
| 1976 | 5 |
| 1977 | 8 |
| 1978 | 4 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 5 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2021 | 1 |
| 2023 | 2 |
| 2025 | 2 |
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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071810'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071810'))
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 NYC82DA234Accident · No injuriesFinal reportCessna 150D · Hyannis, MAThe pilot stated that she was cleared for landing on runway 24. She stated that as she turned onto final, and the aircraft was high, an additional notch of flaps was added. The descent to the runway was at approximately 90 mph. The aircraft touched down in…NTSB DEN82DA168Accident · No injuriesFinal reportCessna 150 · Weldona, COThe plt stated to a FAA inspector that prior to takeoff the fuel gauges indicated approximately 1/4 full in each tank. The inspector indicated the fuel supply was exhausted. Numerous attempts to obtain an accident report from the plt were unsuccessful.NTSB NYC82FGM13Accident · Serious injuriesFinal reportCessna 150D · Patton, PAThe student pilot departed johnston, PA at about 2000 EDT on a return flight to ebensburg, PA. He saw the destination airport at about 2015 EDT and elected to fly locally and practice maneuvers. At about 2045 EDT, he became lost and flew a large rectangular…NTSB LAX82DUG06Accident · Serious injuriesFinal reportCessna 150 · Daggett, CAWhile descending through 4000 ft MSL to land, the engine began to surge. The pilot moved the mixture to full rich and selected carburetor heat, but the engine lost all power. Reportedly, the aircraft was demolished during a forced landing. Disassembly of the…