NTSB investigations: Cessna 172M, LA
15 cases on aircraft the registry lists as Cessna 172M. 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 | 4 |
| 1977 | 1 |
| 1979 | 2 |
| 1980 | 2 |
| 1985 | 2 |
| 1989 | 1 |
| 2001 | 1 |
| 2013 | 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 ('2072418'))
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 ('2072418'))
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 CEN13LA249Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Covington, LAThe pilot’s failure to maintain airspeed during a banner towing operation, which resulted in the airplane stalling and landing hard.NTSB FTW01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Patterson, LAthe pilot's failure to maintain control during the go-around. A contributing factor was the wind gust.NTSB FTW90LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Allen, LAFuel system contamination due to inadequate maintenance/service of the airplane.NTSB FTW85LA304Accident · No injuriesLimited investigationFinal reportCessna 172 M · Arcadia, LAThe plt stated he heard a 'boom' and experienced a partial power loss when he was about 10 ft above the rwy during the initial takeoff climb. He was about half way down the 3000 foot rwy at this time. He aborted the takeoff and landed. However, he was not…NTSB FTW85LA164Accident · No injuriesLimited investigationFinal reportCessna 172M · Angola, LAThe acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this…NTSB FTW81DRD11Accident · No injuriesClosedCessna 172M · Belle Chasse, LANTSB FTW80DRD40Accident · No injuriesClosedCessna 172 · Delacroix, LANTSB FTW79FRD42Accident · No injuriesClosedCessna 172 · Grand Isle, LANTSB FTW79DRD18Accident · No injuriesClosedCessna 172M · Franklinton, LANTSB FTW77DRD23Accident · No injuriesClosedCessna 172 · Melville, LANTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LANTSB FTW76AF113Accident · 1 fatalClosedCessna 172 · Baker, LANTSB FTW76DRJ28Accident · No injuriesClosedCessna 172 · Many, LANTSB FTW76DRJ22Accident · No injuriesClosedCessna 172M · Alexandria, LANTSB FTW76ARD25Accident · Minor injuriesClosedCessna 172 · Lafayette, LA