NTSB investigations: Cessna 150F, 1982
9 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\") = 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 ('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") = 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 ('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 ATL83FKQ01Accident · 2 fatalFinal reportCessna 150F · Sidon, MSThe student pilot and passenger departed jackson on a flight to madison, MS. The highway patrol received a report of a low flying aircraft and a loud noise in the vicinity of Sidon, MS, the aircraft wreckage was found the next morning in a soy bean field. The…NTSB FTW83LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Pine Bluff, ARThe student pilot had made several touch-and-go landings on the same runway. He stated his last approach and touchdown were normal. Reportedly, the nose gear collapsed during the landing roll. The aircraft went off the left side of the runway and flipped…NTSB DEN82DA187Accident · No injuriesFinal reportCessna 150 · Faith, SDThe pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a…NTSB DEN82DA151Accident · No injuriesFinal reportCessna 150F · Sheridan Lake, COThe pilot reported that he was on a flight to check his fields and crops for possible hail damage. Reportedly, he decided to see how a friend was doing with his wheat harvest and to see if he had received hail damage. The pilot stated that he spotted his…NTSB ATL82DA157Accident · No injuriesFinal reportCessna 150F · Monroeville, ALAfter making a normal landing touchdown, the nosewheel was held off until it lowered naturally. The pilot stated that when the nosewheel touched down, it seemed that the wheel would not turn. At about that time, the nose gear collapsed and the propeller,…NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.NTSB LAX82FXQ07Accident · 1 fatalFinal reportCessna 150 · Wadsworth, NVWhile flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to…NTSB FTW82DA126Accident · Minor injuriesFinal reportCessna 150F · Corpus Christi, TXThe pilot stated that he had just finished washing his aircraft and was flying around the airport to dry it off. After takeoff the pilot realized that one of the aileron gust locks had not been removed. A normal landing was attempted, and while on final…