NTSB investigations: Cessna 172H, AZ
10 cases on aircraft the registry lists as Cessna 172H. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1995 | 1 |
| 2009 | 1 |
| 2011 | 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\" = 'AZ' 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 ('2072424'))
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" = 'AZ' 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 ('2072424'))
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 WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.NTSB LAX95LA344Accident · 2 fatalLimited investigationFinal reportCessna 172H · St. Johns, AZthe pilot's failure to assure that the seat adjustment pin was properly engaged prior to takeoff.NTSB LAX85LA246Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Bullhead City, AZThe plt reported that while he was flying & looking for 'wild animals at the base of the mountain' the acft's eng lost power. The acft descended & when it was close to the ground eng power was reacquired. The plt further reported that there was 'severe'…NTSB LAX77FUJ92Accident · Minor injuriesClosedCessna 172 · Wickenburg, AZNTSB LAX76SL071Accident · 1 fatalClosedCessna 172H · Winslow, AZNTSB LAX71DUJ62Accident · No injuriesClosedCessna 172 · Tucson, AZNTSB LAX70D0180Accident · No injuriesClosedCessna 172 · St Johns, AZNTSB LAX68D0017Accident · No injuriesClosedCessna 172 · Phoenix, AZNTSB LAX67D0164Accident · No injuriesClosedCessna 172 · Grand Canyon, AZ