NTSB investigations: Cessna 172, NM
19 cases on aircraft the registry lists as Cessna 172. 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 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 2021 | 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\" = '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 ('2072402'))
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 ('2072402'))
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 WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB DEN88LA209Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Questa, NMThe private plt and 1 pax were taking off using 2,500 ft of a 4,000 x 50 ft dirt strip with a d/a of 9,200 ft. during intial climb the plt noticed a sink rate. The plt said he varied the angle of flaps from 5 to 25 deg 'in search of lift.' The right wing and…NTSB FTW82DA057Accident · No injuriesFinal reportCessna 172 · Navajo Dam, NMThe pilot landed at an unattended airport on what he thought to be approximately 2 inches of snow. It turned out to be 8 inches and the aircraft turned over on landing.NTSB DEN76FQA41Accident · Serious injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN74AD042Accident · 1 fatalClosedCessna 172A · Silver City, NMNTSB DEN73DQD16Accident · No injuriesClosedCessna 172 · Carlsbad, NMNTSB DEN73DQA24Accident · No injuriesClosedCessna 172 · Tanner, NMNTSB DEN72DQG32Accident · No injuriesClosedCessna 172 · Clovis, NMNTSB DEN71DQA05Accident · No injuriesClosedCessna 172 · El Rito, NMNTSB DEN69A0031Accident · 1 fatalClosedCessna 172 · Sandia Park, NMNTSB DEN69F0090Accident · No injuriesClosedCessna 172 · Lordsburg, NMNTSB DEN68F0240Accident · No injuriesClosedCessna 172 · Mountainair, NMNTSB DEN68D0078Accident · No injuriesClosedCessna 172 · Cowles, NMNTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMNTSB DEN66D0011Accident · No injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN65F0111Accident · No injuriesClosedCessna 172 · Albuquerque, NMNTSB UNK65X1148Accident · No injuriesClosedCessna 172 · Grants, NMNTSB UNK64X1860Accident · No injuriesClosedCessna 172 · Clovis, NM