NTSB investigations: Cessna 150F, 1983
6 cases on aircraft the registry lists as Cessna 150F. 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
| 1965 | 34 |
|---|---|
| 1966 | 229 |
| 1967 | 264 |
| 1968 | 172 |
| 1969 | 124 |
| 1970 | 81 |
| 1971 | 68 |
| 1972 | 62 |
| 1973 | 49 |
| 1974 | 50 |
| 1975 | 38 |
| 1976 | 28 |
| 1977 | 18 |
| 1978 | 26 |
| 1979 | 24 |
| 1980 | 21 |
| 1981 | 20 |
| 1982 | 9 |
| 1983 | 6 |
| 1984 | 15 |
| 1985 | 12 |
| 1986 | 15 |
| 1987 | 14 |
| 1988 | 25 |
| 1989 | 8 |
| 1990 | 15 |
| 1991 | 6 |
| 1992 | 14 |
| 1993 | 7 |
| 1994 | 6 |
| 1995 | 8 |
| 1996 | 14 |
| 1997 | 13 |
| 1998 | 11 |
| 1999 | 11 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 8 |
| 2026 | 1 |
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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
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 SEA84LA027Accident · No injuriesLimited investigationFinal reportCessna 150F · Prosser, WAAccording to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…NTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.NTSB DEN83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Red Owl, SDBefore the flt the student pilot had checked the fuel by the gages only and had not drained the fuel sumps. He thought he had enough fuel to fly from the ranch to the training school arpt to refuel. The engine quit at 100 ft AGL after takeoff. About 1-1/2…NTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…NTSB LAX83FVA02Accident · Serious injuriesFinal reportCessna 150F · Coulterville, CAThe pilot made two telephone calls to the fss requesting wx briefings for a VFR flt to medford, OR. He was provided with a summary of the current and forecast wx for his route and destination. He was advised that VFR flt was not recommended for that day. The…NTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…