Skip to content

NTSB investigations: Cessna 180, NM

20 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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.Jul 14, 2024 · N1000Y · Substantial damage NTSB WPR22LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Carrizozo, NMThe pilot's failure to maintain directional control during the landing roll.Feb 10, 2022 · N4750B · Substantial damage NTSB CEN13LA541Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMThe pilot's failure to maintain airplane directional control during the landing roll due to his diverted attention.Sep 7, 2013 · N561AT · Substantial damage NTSB CEN13CA223Accident · No injuriesData collectionFinal reportCessna 180 · Roswell, NMThe pilot's failure to maintain directional control on the landing roll after encountering a gust of wind, which resulted in a ground loop.Mar 29, 2013 · N7714A · Substantial damage NTSB CEN11CA026Accident · No injuriesData collectionFinal reportCessna 180 · Farmington, NMThe failure of the pilot and the flight instructor to maintain directional control of the airplane during a training maneuver.Oct 10, 2010 · N9277C · Substantial damage NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.Aug 20, 1999 · N4796B · Substantial damage NTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.Jun 20, 1998 · N3196D · Substantial damage NTSB DEN84LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMDuring the landing roll, the right gear collapsed & the acft veered off the rwy. An exam revealed that the right wheel ass'y had separated from the gear leg. There was evidence that the 2 lower bolts had been stripped prior to the wheel failure, either by…Jun 21, 1984 · N153M · Substantial damage NTSB DEN79DQD10Accident · No injuriesClosedCessna 180 · Las Cruces, NMMay 26, 1979 · N9004C · Substantial damage NTSB DEN76FQA48Accident · No injuriesClosedCessna 180 · Farmington, NMJun 5, 1976 · N3228D · Substantial damage NTSB DEN76FQA23Accident · Serious injuriesClosedCessna 180 · Zuni, NMNov 7, 1975 · N2420C · Destroyed NTSB DEN75FQA31Accident · Serious injuriesClosedCessna 180 · Ruidoso, NMFeb 8, 1975 · N2996A · Destroyed NTSB DEN75FQA21Accident · Serious injuriesClosedCessna 180 · San Mateo, NMDec 1, 1974 · N3697C · Destroyed NTSB DEN72FQA36Accident · Minor injuriesClosedCessna 180 · Albuquerque, NMApr 8, 1972 · N3128D · Substantial damage NTSB DEN69A0036Accident · 2 fatalClosedCessna 180 · Tucumcari, NMMar 7, 1969 · N3371D · Destroyed NTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NMJul 5, 1968 · N180Y · Substantial damage NTSB DEN68A0046Accident · 2 fatalClosedCessna 180 · Rociada, NMApr 14, 1968 · N9047C · Destroyed NTSB DEN66D0093Accident · No injuriesClosedCessna 180 · Belen, NMSep 5, 1965 · N3861C · Substantial damage NTSB DEN65D0042Accident · No injuriesClosedCessna 180 · Roswell, NMFeb 28, 1965 · N9286C · Substantial damage NTSB UNK64X3017Accident · No injuriesClosedCessna 180 · Albuquerque, NMJul 25, 1964 · N4909A · Substantial damage