NTSB investigations: Cessna 150E
6 cases on aircraft the registry lists as Cessna 150E, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2007 | 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 ('2071812')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('2071812')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.NTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB SEA94LA219Accident · No injuriesLimited investigationFinal reportCessna 150E · Mcminnville, ORThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include soft terrain in the vicinity of the runway.NTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…NTSB DEN85LA031Accident · No injuriesLimited investigationFinal reportCessna 150E · Wallsburg, UTThe acft swerved off the rwy and nosed over after colliding with a dirt bank and a ditch. The plt said that at touchdownon the gravel ranch strip he felt a bump and the acft veered to the edge of the rwy. He added that power was applied forthe go-around but…