NTSB investigations: Cessna 172A
9 cases on aircraft the registry lists as Cessna 172A, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC07LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Sarasota, FLThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during landing, and collision with objects. Factors associated with the accident were wind gusts and a crosswind.NTSB SEA06CA041Accident · No injuriesData collectionFinal reportCessna 172A · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the berm.NTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.NTSB LAX95LA316Accident · No injuriesLimited investigationFinal reportCessna 172A · Weed, CAthe flight instructor's failure to maintain directional control of the aircraft.NTSB FTW88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Cleveland, TXThis acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…NTSB LAX83LA284Accident · No injuriesLimited investigationFinal reportCessna 172A · Carmel Valley, CAAccording to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…NTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…