NTSB investigations: Cessna 172S, NV
7 cases on aircraft the registry lists as Cessna 172S. 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
| 2002 | 1 |
|---|---|
| 2007 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2017 | 2 |
| 2019 | 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\" = 'NV' 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 ('2072439', '2072442'))
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" = 'NV' 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 ('2072439', '2072442'))
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 GAA19CA113Accident · No injuriesData collectionFinal reportCessna 172 · Reno, NVThe student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.NTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…NTSB GAA17CA248Accident · No injuriesData collectionFinal reportCessna 172S · Jean, NVThe pilot’s runway selection, which resulted in landing with a tailwind and an unstabilized approach and subsequent runway overrun.NTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…NTSB LAX07CA170Accident · No injuriesData collectionFinal reportCessna 172S · Carson City, NVThe loss of directional control for undetermined reasons.NTSB LAX02LA192Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Goldfield, NVThe pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.