NTSB investigations: Cessna 150L
10 cases on aircraft the registry lists as Cessna 150L, where the sequence of events included Aerodynamic stall/spin. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2018 | 1 |
| 2021 | 2 |
| 2024 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('2071826')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.NTSB ERA21LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Fort Lauderdale, FLThe flight instructor’s loss of airplane control during an attempted go around maneuver, which resulted in an aerodynamic stall, and subsequent impact with the runway.NTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.NTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…NTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA11CA363Accident · Minor injuriesData collectionFinal reportCessna 150L · Winter Haven, FLThe certified flight instructor's failure to maintain control during the attempted go-around, which resulted in an aerodynamic stall.NTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…