NTSB investigations: Cessna 180, MD
11 cases on aircraft the registry lists as Cessna 180. 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
| 1964 | 2 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1998 | 1 |
| 2017 | 1 |
| 2022 | 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\" = 'MD' 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 ('2072602'))
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" = 'MD' 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 ('2072602'))
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 ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB ERA18LA043Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Frederick, MDThe pilot's improper landing flare, which resulted in a bounced landing and the failure of the left main landing gear tire.NTSB NYC98LA186Accident · No injuriesLimited investigationFinal reportCessna 180 · Lakeshore, MDFailures of the right float's nose wheel do to a preexisting fatigue crack.NTSB BFO88LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Annapolis, MDDuring the landing rollout the aircraft drifted to the left. The left main wheel departed the pavement and encountered soft terrain. The aircraft groundlooped and nosed over. The pilot did not file an accident report.NTSB NYC84LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Leonardtown, MDThe acft made a forced landing about 1 mile sw of an added stopping point. The plt noted a lower than planned gs and thought he should add a stop for fuel. During the flt he had encountered icing and because of climbs and descents to avoid wx for about an…NTSB IAD76FIA13Accident · No injuriesClosedCessna 180 · Clinton, MDNTSB IAD75FIG17Accident · Minor injuriesClosedCessna 180 · Laurel, MDNTSB IAD75FIG09Accident · No injuriesClosedCessna 180 · Ridgely, MDNTSB NYC73FIG01Accident · No injuriesClosedCessna 180 · Ridgely, MDNTSB UNK64X3660Accident · No injuriesClosedCessna 180 · Aberdeen, MDNTSB UNK64X2662Accident · No injuriesClosedCessna 180 · Cockeysville, MD