NTSB investigations: Cessna 172E, AR
10 cases on aircraft the registry lists as Cessna 172E. 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 | 1 |
|---|---|
| 1967 | 4 |
| 1972 | 1 |
| 1974 | 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\" = 'AR' 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 ('2072412'))
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" = 'AR' 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 ('2072412'))
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 CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB MKC88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Harrison, ARWhile in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting…NTSB FTW82DA149Accident · Minor injuriesFinal reportCessna 172 · Delaplane, AROn landing the pilot noticed braking action was poor due to wet grass on the strip. The nose of the aircraft struck a soft spot on the runway, sank in and sheared off the nose gear. The aircraft then nosed over. Investigation revealed the pilot/owner had…NTSB FTW74DPG44Accident · No injuriesClosedCessna 172E · Springdale, ARNTSB FTW72FPG59Accident · No injuriesClosedCessna 172 · Parkin, ARNTSB FTW68D0082Accident · Minor injuriesClosedCessna 172 · Huttig, ARNTSB FTW68D0062Accident · No injuriesClosedCessna 172 · Griffithville, ARNTSB FTW67D0643Accident · No injuriesClosedCessna 172 · Earle, ARNTSB FTW67F0479Accident · No injuriesClosedCessna 172 · Hughes, ARNTSB UNK64X3815Accident · No injuriesClosedCessna 172E · Flippin, AR