Skip to content

Final NTSB investigations: Cessna 172Q

13 cases on aircraft the registry lists as Cessna 172Q. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

Where

Latest cases

Query with SQL

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072437')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072437'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072437'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR20LA068Accident · No injuriesClass 3 · LimitedFinal reportCessna 172Q · Big Timber, MTA loss of engine power during climbout for undetermined reasons.Jan 17, 2020 · N96145 · Substantial damage NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.Mar 16, 2002 · N66076 · Destroyed NTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.Jul 3, 2001 · N66076 · Substantial damage NTSB DEN99FA077Accident · No injuriesField investigationFinal reportCessna 172Q · Greeley, COFailure of both the pilot receiving instruction and the flight instructor to maintain a visual lookout. A factor was the failure of the other pilot to maintain a visual lookout.May 13, 1999 · N96299 · 2 aircraft · Minor damage NTSB LAX96LA306Accident · Minor injuriesLimited investigationFinal reportCessna 172Q · Kayenta, AZthe pilot's failure to adhere to the manufacturer's performance data by not maintaining the recommended best rate of climb speed, resulting in an inadvertent stall/mush event. The high density altitude was a related factor.Aug 14, 1996 · N65963 · Substantial damage NTSB MIA96LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Ormond Beach, FLThe student pilot's improper recovery from a bounced landing and his failure to execute a go-around. Contributing to the accident were: the student pilot's high, fast approach and his misjudgment of the flare during landing.Oct 20, 1995 · N913AT · Substantial damage NTSB ATL94T#A02Accident · No injuriesClass 3Final reportCessna 172Q · Louisville, GAAug 30, 1994 · N96960 · Substantial damage NTSB DEN92LA043Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COUndetermined.Mar 18, 1992 · N66076 · Substantial damage NTSB MKC90LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Hiwasse, ARThe pilot's failure to properly plan the flight and insure that there was sufficient fuel to complete the flight. The pilot also failed to monitor the fuel level during the flight.Oct 20, 1989 · N96299 · Substantial damage NTSB DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, COSep 19, 1988 · N66076 · Destroyed NTSB DEN88LA101Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COApr 28, 1988 · N96299 · Substantial damage NTSB LAX84FA498Accident · Minor injuriesField investigationFinal reportCessna 172Q · Prescott, AZDuring a descent to the 5,042 ft elevation arpt the acft impacted the trees and mountainous terrain at the 7,000 ft level. According to the pilot, with the hooded student pilot at the controls, the flight began it's descent from 10,500 ft 30 miles from the…Sep 27, 1984 · N915ER · Destroyed NTSB SEA73DYE35Accident · No injuriesClosedCessna 172S · La Conner, WAMay 19, 1973 · N3897Q · Substantial damage