NTSB investigations: Cessna 182P, LA
9 cases on aircraft the registry lists as Cessna 182P. 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
| 1976 | 2 |
|---|---|
| 1977 | 1 |
| 1978 | 2 |
| 1982 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 2025 | 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 ('2075816'))
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 ('2075816'))
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 CEN25LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182P · Kentwood, LAOn May 3, 2025, about 1530 central daylight time, a Cessna 182P, N9415M, was substantially damaged when it was involved in an accident near Kentwood, Louisiana. The pilot sustained serious injuries, and the passenger sustained minor injuries. The airplane was…NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.NTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.NTSB FTW82DA310Accident · No injuriesFinal reportCessna 182P · Abbeville, LAThe pilot was on a cross-country ferry flight when the engine lost power. A forced landing was made in a field of tall rice. The pilot stated that during the landing, the aircraft struck a rice levee and nosed over. The source of engine failure was not…NTSB FTW78FA040Accident · 1 fatalClosedCessna 182P · Ferriday, LANTSB FTW78DPJ14Accident · Minor injuriesClosedCessna 182A · Monroe, LANTSB FTW78DRD10Accident · Minor injuriesClosedCessna 182P · White Castle, LANTSB FTW77FRJ02Accident · Minor injuriesClosedCessna 182 · Arcadia, LANTSB FTW76FRJ20Accident · Serious injuriesClosedCessna 182P · Jones, LA