Skip to content

NTSB investigations: Cessna 180, FL

24 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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" = 'FL' 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

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\" = 'FL' 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" = 'FL' 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

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 GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.Nov 10, 2017 · N6547A · Substantial damage NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.Nov 12, 2007 · N9198C · Substantial damage NTSB MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.Mar 4, 2006 · N9138C · Substantial damage NTSB ATL02LA126Accident · No injuriesLimited investigationFinal reportCessna 180 · Jacksonville, FLThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop. A factor related to the accident was the certified flight instructors inadequate supervision of the training flight.Jun 19, 2002 · N9150C · Substantial damage NTSB MIA80DLD07Accident · No injuriesClosedCessna 180 · Brooksville, FLNov 4, 1979 · N3122C · Substantial damage NTSB MIA79DKT52Accident · No injuriesClosedCessna 180 · Key Largo, FLApr 7, 1979 · N9393C · Substantial damage NTSB MIA78FLA41Accident · No injuriesClosedCessna 180 · Jacksonville, FLJun 26, 1978 · N2378C · Substantial damage NTSB MIA76DLD58Accident · Serious injuriesClosedCessna 180 · Lake Placid, FLMay 27, 1976 · N4616A · No damage NTSB MIA74DLD76Accident · No injuriesClosedCessna 180 · Tampa, FLMar 25, 1974 · N4678B · Substantial damage NTSB MIA74DKT45Accident · No injuriesClosedCessna 180 · Delray Beach, FLDec 29, 1973 · N4571B · Substantial damage NTSB MIA73DKT10Accident · Minor injuriesClosedCessna 180 · Homestead, FLJul 1, 1972 · N4571B · Substantial damage NTSB MIA72DLA37Accident · No injuriesClosedCessna 180A · Gainesville, FLApr 6, 1972 · N3136C · Substantial damage NTSB MIA72FLD08Accident · Serious injuriesClosedCessna 180 · Brandon, FLAug 21, 1971 · N204JG · Substantial damage NTSB MIA71ALD22Accident · No injuriesClosedCessna 180 · Rockledge, FLOct 2, 1970 · N2946C · Substantial damage NTSB MIA70DLA02Accident · No injuriesClosedCessna 180 · Panama City, FLFeb 1, 1970 · N2219C · Substantial damage NTSB MIA70FKT04Accident · No injuriesClosedCessna 180 · S.Miami, FLJan 28, 1970 · N3185D · Substantial damage NTSB MIA70F0266Accident · No injuriesClosedCessna 180 · Homestead, FLDec 20, 1969 · N4571B · Substantial damage NTSB MIA67D0534Accident · No injuriesClosedCessna 180 · Opa Locka, FLApr 26, 1967 · N2870A · Substantial damage NTSB MIA67D0439Accident · No injuriesClosedCessna 180 · Davie, FLMar 12, 1967 · N2442C · Substantial damage NTSB MIA67A0046Accident · 2 fatalClosedCessna 180 · Englewood, FLOct 16, 1966 · N2862A · Destroyed NTSB MIA66D0027Accident · No injuriesClosedCessna 180 · Ft Lauderdale, FLJun 19, 1965 · N9104C · Substantial damage NTSB MIA66D0026Accident · No injuriesClosedCessna 180 · W Hollywood, FLJun 19, 1965 · N2442C · Substantial damage NTSB UNK65X0447Accident · Minor injuriesClosedCessna 180 · St George, FLOct 26, 1964 · N2950A · Substantial damage NTSB UNK64X1381Accident · No injuriesClosedCessna 180 · Ft Lauderdale, FLApr 19, 1964 · N2442C · Substantial damage