NTSB investigations: Cessna 150F, 1987
14 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\") = 1987
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") = 1987
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 FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.NTSB LAX88LA036Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Carmel Valley, CAThe plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after…NTSB NYC88LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Millbrook, NYThe aircraft had just become airborne when power fluctuation occurred. On the second power loss, carburetor heat was applied but the engine lost power completely. The instructor pilot was making a turn back towards the airport when the wing contacted trees…NTSB MKC88LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, ARDuring tkof from a private 1500 foot airstrip the student plt stated that the acft would not climb and began to settle. He realized he was losing airspeed and did not have enough altitude to trade for airspeed so he chopped the throttle and made an emergency…NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.NTSB NYC87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Roseville, PAWitnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found.NTSB FTW87LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Red Oak, TXThe pilot stated the aircraft did not appear to lift properly. It gained about 50 feet altitude after liftoff but then settled back to the ground. The departure runway was concrete and was 1200 feet in length. The field elevation was 650 feet MSL and the…NTSB LAX87LA215Accident · No injuriesLimited investigationFinal reportCessna 150F · Bermuda Dunes, CAThe flt encountered strong head winds while cruising x-country at 6000 ft MSL. The engine lost power aprx 14 miles east of the intended destination and during descent toward the destination the power returned several times but could not be maintained. The…NTSB DEN87LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, COThe student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft…NTSB ATL87LA109Accident · No injuriesLimited investigationFinal reportCessna 150F · Branchville, ALThe plt reported that the acft appeared to be 'hot' on final approach due to a tailwind, while ldg at the private airstrip. He initiated a go-around to avoid 50-60 ft trees at the FAR end of the rwy and made a climbing right turn. The stall warning system…NTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…NTSB FTW87FA047Accident · Serious injuriesField investigationFinal reportCessna 150F · Rio Vista, TXPrivate pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…NTSB ATL87FA052Accident · 2 fatalField investigationFinal reportCessna 150F · Newville, ALThe aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the…