NTSB investigations: Cessna 150F
10 cases on aircraft the registry lists as Cessna 150F, where the defining event was Loss of control in flight. 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
| 2011 | 1 |
|---|---|
| 2012 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN24LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Castroville, TXThe pilot’s inadequate recovery from a bounced landing and his failure to maintain proper airplane pitch control and airspeed during the go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall at a low…NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB CEN21LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Rock Falls, ILThe right seat pilot’s improper decision to perform a low approach with full flaps and the failure of the flaps to retract during the attempted go-around, which resulted in a forced landing.NTSB GAA16CA198Accident · No injuriesData collectionFinal reportCessna 150 · Sterling City, TXThe pilot's failure to establish a climb and maintain directional control during takeoff in quartering tailwind conditions, which resulted in a loss of directional control, aborted takeoff, collision with a wire fence, and nose over.NTSB ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.NTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.