NTSB investigations: Cessna 150L, OK
17 cases on aircraft the registry lists as Cessna 150L. 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
| 1971 | 1 |
|---|---|
| 1973 | 3 |
| 1974 | 1 |
| 1977 | 4 |
| 1978 | 1 |
| 1980 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'OK' 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 ('2071826'))
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" = 'OK' 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 ('2071826'))
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 DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DFW06CA045Accident · Minor injuriesData collectionFinal reportCessna 150L · Tulsa, OKThe pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.NTSB FTW01LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Miami, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB FTW91LA160Accident · 1 fatalLimited investigationFinal reportCessna 150L · Collinsville, OKThe inadvertent stall by the pilot. A factor was the improper departure flap setting.NTSB FTW80FA122Accident · 2 fatalClosedCessna 150L · Hendrix, OKNTSB FTW78FPM23Accident · No injuriesClosedCessna 150L · Pawhuska, OKNTSB FTW78FA004Accident · 2 fatalClosedCessna 150L · Dewey, OKNTSB FTW77FPJ37Accident · Minor injuriesClosedCessna 150 · Enid, OKNTSB FTW77FPM05Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW77DPJ06Accident · No injuriesClosedCessna 150 · Medford, OKNTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKNTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKNTSB FTW73DPJ18Accident · Minor injuriesClosedCessna 150L · Enid, OKNTSB FTW72DPJ01Accident · Minor injuriesClosedCessna 150L · Yukon, OK