Skip to content

NTSB investigations: Cessna 172N, LA

21 cases on aircraft the registry lists as Cessna 172N. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Where

Latest cases

Query with SQL

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 ('2072434')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072434'))
  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 ('2072434'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · New Orleans, LAOn November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…Nov 25, 2025 · N80FP · Destroyed NTSB CEN20CA040Accident · Minor injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot's failure to attain an adequate climb rate during an aborted landing with a left quartering, gusting headwind, which resulted in impact with a tree.Dec 23, 2019 · N739SB · Substantial damage NTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…Aug 17, 2014 · N734YW · Substantial damage NTSB CEN13CA246Accident · No injuriesData collectionFinal reportCessna 172N · New Orleans, LAThe pilot's failure to perform a steep climb before going around following a low pass for a banner tow pickup.Apr 28, 2013 · N737FK · Substantial damage NTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.Oct 17, 2011 · N2401E · Substantial damage NTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.Aug 18, 2011 · N3209E · Substantial damage NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.Dec 12, 1999 · N739ST · Substantial damage NTSB FTW00LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pineville, LAThe student pilot's misjudgment of distance/speed during approach resulting in his failure to attain the proper touchdown point.Oct 29, 1999 · N5301E · Substantial damage NTSB FTW90LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandeleur Isld, LAMinimum airspeed required for flight (vs) was not maintained. Contributing factors were the pilot's fatigued condition, and premature lift off.Jun 6, 1990 · N1071S · Substantial damage NTSB FTW90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bastrop, LAFailure of the pilot to maintain adequate airspeed for a go-around, which resulted in an inadvertent stall. Factors related to the accident were: the unfavorable wind condition and turbulence.Mar 10, 1990 · N3530E · Substantial damage NTSB FTW86LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Vick, LAThe pilot was given incorrect information as to the location of his destination airstrip. However, he found an airstrip at that approximate location. It was a 2500 foot grass strip as opposed to the 3600 foot grass strip which he was expecting. While on the…Sep 5, 1986 · N737XJ · Substantial damage NTSB FTW84LA395Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mandeville, LAThe acft made an emerg landing on the south lanes of the lake pontchatrane causeway bridge after encountering a loss of eng power. Examination of the acft fuel tanks revealed both tanks empty. Activation of the fuel tank drain valves & the fuel strainer…Sep 14, 1984 · N737LD · Substantial damage NTSB FTW84LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Thibodaux, LAThe acft nosed over during a forced landing after the engine quit. A FBO visually inspected the wreckage acft and found little gas and a lack of fuel odor around the acft. Later the engine was refueled and ran normally. The 3 acft fuel tanks were found empty…Feb 9, 1984 · N2103E · Substantial damage NTSB FTW83FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Pineville, LAThe owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed…Feb 23, 1983 · N4862G · Destroyed NTSB FTW81FRD04Accident · No injuriesClosedPitts S-2A · New Orleans, LANov 4, 1980 · N333BD · 2 aircraft · Substantial damage NTSB FTW80DRD31Accident · No injuriesClosedCessna 172N · Braithwaite, LAMay 1, 1980 · N3151E · Substantial damage NTSB FTW79FA107Accident · 1 fatalClosedCessna 172N · Lafayette, LASep 8, 1979 · N1944F · Destroyed NTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LAMar 10, 1979 · N737XR · Destroyed NTSB FTW78DRD43Accident · Minor injuriesClosedCessna 172 · Empire, LAJul 3, 1978 · N7268Q · 2 aircraft · Destroyed NTSB FTW78DRD40Accident · No injuriesClosedCessna 172 · Bogalusa, LAJun 25, 1978 · N734NA · Substantial damage NTSB FTW78FRD38Accident · No injuriesClosedCessna 172 · Kaplan, LAJun 18, 1978 · N737FH · Substantial damage