NTSB investigations: Cessna 180J, LA
20 cases on aircraft the registry lists as Cessna 180J. 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
| 1974 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 3 |
| 1980 | 2 |
| 1981 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 2010 | 1 |
| 2024 | 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 ('2072622'))
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 ('2072622'))
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 CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…NTSB FTW84FA354Accident · 2 fatalField investigationFinal reportCessna 180J · Lafitte, LAWitnesses observed the acft approach an oil production platform located in a marshy area near the destination airstrip. They reported that the acft made an abrupt, steep left turn at 200 to 300 ft AGL, followed by what they described as an accelerated stall.…NTSB FTW84LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Slidell, LAThe acft collided with submerged objects during takeoff. The takeoff was aborted and the acft ran up on the bayou bank where it collided with trees.NTSB FTW81DRD37Accident · No injuriesClosedCessna 180J · Dulac, LANTSB FTW81DRD33Accident · No injuriesClosedCessna 180J · Morgan City, LANTSB FTW80DRJ45Accident · No injuriesClosedCessna 180 · Pitkin, LANTSB FTW80DRD27Accident · No injuriesClosedCessna 180 · Patterson, LANTSB FTW79FRD24Accident · Minor injuriesClosedCessna 180J · Harvey, LANTSB FTW79DA057Accident · No injuriesClosedCessna 180J · Morgan City, LANTSB FTW79DRD13Accident · No injuriesClosedCessna 182F · Venice, LANTSB FTW78DRD52Accident · Minor injuriesClosedCessna 180F · Buras, LANTSB FTW78DRJ21Accident · No injuriesClosedCessna 180J · Shreveport, LANTSB FTW78FAQ41Accident · 1 fatalClosedCessna 180J · New Orleans, LANTSB FTW78DRD18Accident · Minor injuriesClosedCessna 180J · Westwego, LANTSB FTW77DRD20Accident · No injuriesClosedCessna 180J · Dulac, LANTSB FTW76DRD51Accident · No injuriesClosedCessna 180 · Bayon Pigeon, LANTSB FTW76FRD43Accident · No injuriesClosedCessna 180 · Port Sulphur, LANTSB FTW75DRJ29Accident · Serious injuriesClosedCessna 180J · Tallulah, LANTSB FTW74AF081Accident · No injuriesClosedCessna 185 · Lafitte, LA