NTSB investigations: Cessna A185E, LA
13 cases on aircraft the registry lists as Cessna A185E. 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
| 1967 | 1 |
|---|---|
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1977 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 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 ('2072818'))
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 ('2072818'))
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 FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…NTSB FTW82DA213Accident · No injuriesFinal reportCessna A185E · Lafayette, LAThe pilot stated that during a water landing the right main landing gear dropped down causing the aircraft to swerve to the right. The left wing contacted the water and received substantial damage. The reason for the gear to drop out was never determined.NTSB FTW80DRD36Accident · No injuriesClosedCessna 185 · Morgan City, LANTSB FTW77FA058Accident · 3 fatalClosedCessna 185 · Houma, LANTSB FTW77DRD14Accident · Minor injuriesClosedCessna 185A · Houma, LANTSB FTW75DRD11Accident · No injuriesClosedCessna A185E · Patterson, LANTSB FTW74AF081Accident · No injuriesClosedCessna 185 · Lafitte, LANTSB FTW73DRD01Accident · No injuriesClosedCessna A185E · Jeanerette, LANTSB FTW71FRD49Accident · No injuriesClosedCessna A185E · New Orleans, LANTSB FTW71FRD26Accident · Minor injuriesClosedCessna A185E · Centerville, LANTSB FTW68D0569Accident · Minor injuriesClosedCessna 185 · Houma, LANTSB FTW68D0441Accident · No injuriesClosedCessna 185E · Gum Cove, LANTSB FTW68F0201Accident · No injuriesClosedCessna 185A · Houma, LA