NTSB investigations: Cessna 150M, LA
16 cases on aircraft the registry lists as Cessna 150M. 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
| 1975 | 1 |
|---|---|
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2010 | 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\" = '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 ('2071830'))
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 ('2071830'))
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 CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.NTSB FTW90FA168Accident · 2 fatalField investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain flying speed which resulted in an inadvertent stall during the steep turn. A factor was the door opening in flight.NTSB FTW84LA109Accident · No injuriesLimited investigationFinal reportCessna 150M · New Orleans, LADuring arrival, the acft lost power after a descent from 3000 to 2000 ft. at that time, the plt noted that the fuel gages indicated each tank was 1/8 full, but he did not apply carb heat until he was in an emergency descent. He elected to land on a boulevard.…NTSB FTW82DA358Accident · Minor injuriesFinal reportCessna 150 · Farmerville, LAThe pilot made a downwind takeoff from an intersection of the runway. The aircraft failed to clear trees at the departure end of the runway.NTSB FTW80FRD56Accident · Serious injuriesClosedCessna 150 · Sulphur, LANTSB FTW80DRJ24Accident · No injuriesClosedCessna 150 · Monroe, LANTSB FTW80FRJ07Accident · Minor injuriesClosedCessna 150M · Ruston, LANTSB FTW79DA102Accident · No injuriesClosedCessna 180 · Mandeville, LANTSB FTW79DRD48Accident · No injuriesClosedCessna 150 · New Roads, LANTSB FTW78FRD56Accident · No injuriesClosedCessna 150 · Lake Charles, LANTSB FTW77FRJ23Accident · 1 fatalClosedCessna 150M · Oil City, LANTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LANTSB FTW76AF082Accident · 1 fatalClosedCessna 177 · New Iberia, LANTSB FTW75FRD27Accident · No injuriesClosedCessna 150 · New Orleans, LA