NTSB investigations: Cessna 150D, 1986
3 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\") = 1986
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") = 1986
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 MKC87LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Nevada, MOThe PIC preflighted his acft prior to departure, but the preflight did not include refueling the acft which contained about 8 gallons of fuel. Normally the 8 gallons of fuel would have been sufficient to reach the destination arpt which was 21 statute miles…NTSB LAX86LA302Accident · 1 fatalLimited investigationFinal reportCessna 150D · San Diego, CAA Cessna 150D collided with the pacific ocean while spotting fish approximately 5 mi from the coast. The acft owner and operator indicated that the plt was FAA licensed and current. FAA records revealed the plt was issued a student plt certificated along with…NTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…