NTSB investigations: Cessna 150E, SC
7 cases on aircraft the registry lists as Cessna 150E. 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
| 1967 | 1 |
|---|---|
| 1970 | 1 |
| 1973 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
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."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
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 ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.NTSB MIA97LA225Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe improper rebuild/remanufacture of the fuel line (obstructed at both ends) that runs between the carburetor and sediment bowl by an unknown person. This resulted in a loss of engine power due to fuel starvation, forced landing to non-suitable terrain, and…NTSB ATL93LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Pelion, SCThe pilot's improper weather evaluation prior to commencing the flight. Factors were the fog and low ceiling weather conditions, and the rough, uneven terrain at the landing siteNTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.NTSB MIA74AM006Accident · 3 fatalClosedCessna 150E · Andrews, SCNTSB MIA70FLG08Accident · No injuriesClosedCessna 150 · Gaffney, SCNTSB MIA68D0288Accident · No injuriesClosedCessna 150 · Lancaster, SC