NTSB investigations: Cessna 150L, LA
18 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
| 1972 | 2 |
|---|---|
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 3 |
| 1976 | 2 |
| 1977 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 2009 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'LA' 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" = 'LA' 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 CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB CEN11CA221Accident · No injuriesData collectionFinal reportCessna 150L · Gonzales, LAThe flight instructor's failure to monitor the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…NTSB FTW90FA152Accident · 2 fatalField investigationFinal reportCessna 150L · Leesville, LAThe pilot's failure to maintain vs while maneuvering and the fact that altitude was insufficient for recovery from the inadvertent stall.NTSB FTW89FA042Accident · 1 fatalField investigationFinal reportCessna 150L · Zachary, LAThe pilot's loss of aircraft control due to spatial disorientation after encountering instrument meteorological weather conditions (IMC) shortly after takeoff, his intentional takeoff into adverse weather conditions, and the operator's inadequate supervision…NTSB FTW77FRJ13Accident · No injuriesClosedCessna 150L · Leesville, LANTSB FTW76DRD49Accident · No injuriesClosedCessna 150 · Lake Charles, LANTSB FTW76DRD37Accident · No injuriesClosedCessna 150 · Hathaway, LANTSB FTW76AF034Accident · 2 fatalClosedCessna 150 · Oak Grove, LANTSB FTW75FRD40Accident · No injuriesClosedCessna 150 · Arnaudville, LANTSB FTW75FRD26Accident · Serious injuriesClosedCessna 150L · Kinder, LANTSB FTW74DRJ08Accident · Minor injuriesClosedCessna 150L · Vidalia, LANTSB FTW74AF085Accident · 1 fatalClosedCessna 150L · Abita Springs, LANTSB FTW74DRJ19Accident · Minor injuriesClosedCessna 150 · Minden, LANTSB FTW74FRD16Accident · No injuriesClosedCessna 150L · Clinton, LANTSB FTW73FRD24Accident · Minor injuriesClosedCessna 150L · Baton Rouge, LANTSB FTW73FRJ21Accident · No injuriesClosedCessna 150L · Shreveport, LANTSB FTW73FRJ11Accident · No injuriesClosedCessna 150 · Natchitoches, LA