Skip to content

NTSB investigations: Cessna 172, IN

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

19642026

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."eventStateOrRegion" = 'IN' 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 ('2072402')) 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.\"eventStateOrRegion\" = 'IN' 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 ('2072402'))
  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" = 'IN' 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 ('2072402'))
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 CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.Dec 3, 1988 · N5728A · Substantial damage NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INJul 27, 1988 · N6818A · Substantial damage NTSB CHI88LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172 · North Liberty, INWhile departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…May 22, 1988 · N5848A · Substantial damage NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…Aug 6, 1983 · N8164B · Substantial damage NTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INDec 26, 1981 · N5072A · Destroyed NTSB CHI81FEX13Accident · No injuriesClosedCessna 172 · Marion, INApr 5, 1981 · N4104F · Substantial damage NTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, INMay 10, 1980 · N3912F · Destroyed NTSB CHI79FET05Accident · No injuriesClosedCessna 172 · South Bend, INNov 5, 1978 · N7023A · Substantial damage NTSB CHI79FEX05Accident · Minor injuriesClosedCessna 172 · Martinsville, INNov 3, 1978 · N6861A · Substantial damage NTSB CHI78FEX31Accident · 1 fatalClosedCessna 172 · Evansville, INAug 14, 1978 · N7071T · Destroyed NTSB CHI77FEX25Accident · Minor injuriesClosedCessna 172 · Indianapolis, INMay 8, 1977 · N8685B · Substantial damage NTSB CHI76FET48Accident · No injuriesClosedCessna 172 · Griffith, INAug 17, 1976 · N5750A · Substantial damage NTSB CHI76DEA27Accident · No injuriesClosedCessna 172 · Kokomo, INFeb 9, 1976 · N4104F · Destroyed NTSB CHI75DEA01Accident · No injuriesClosedCessna 172 · Anderson, INJul 8, 1974 · N7410A · Substantial damage NTSB CHI74DEA46Accident · No injuriesClosedCessna 172 · Greentown, INJun 12, 1974 · N4104F · Substantial damage NTSB CHI72FET18Accident · Serious injuriesClosedCessna 172 · Elkhart, INMar 12, 1972 · N5632A · Destroyed NTSB CHI71FBA32Accident · No injuriesClosedCessna 172 · Frankfort, INMar 10, 1971 · N8895B · Substantial damage NTSB CHI71FBM13Accident · No injuriesClosedCessna 172 · Claypool, INJan 17, 1971 · N5898A · Substantial damage NTSB CHI70F0254Accident · Minor injuriesClosedCessna 172 · Hobart, INAug 3, 1969 · N6654A · Substantial damage NTSB CHI69F0381Accident · No injuriesClosedCessna 172 · Shelbyville, INNov 25, 1968 · N7238A · Destroyed NTSB CHI69F0067Accident · Serious injuriesClosedCessna 172 · Fairbanks, INJun 18, 1968 · N6084A · Destroyed NTSB CHI68F0747Accident · No injuriesClosedCessna 172 · Gary, INMay 2, 1968 · N7028A · Substantial damage NTSB CHI68A0064Accident · 2 fatalClosedCessna 172 · Liberty, INJan 21, 1968 · N4142F · Destroyed NTSB CHI68D0510Accident · No injuriesClosedCessna 172 · Greenwood, INDec 20, 1967 · N4033F · Substantial damage NTSB CHI67F0673Accident · No injuriesClosedCessna 172 · Franklin, INJun 6, 1967 · N3920F · Substantial damage NTSB CHI67D0645Accident · No injuriesClosedCessna 172 · Otterbein, INMay 1, 1967 · N6335E · Substantial damage NTSB CHI66D0746Accident · No injuriesClosedCessna 172 · Angola, INApr 29, 1966 · N5999A · Substantial damage NTSB CHI66D0379Accident · No injuriesClosedCessna 172 · Greenwood, INOct 17, 1965 · N6105E · Substantial damage NTSB CHI65D0167Accident · No injuriesClosedCessna 172 · Lafayette, INMay 19, 1965 · N7475A · Substantial damage NTSB UNK64X2447Accident · No injuriesClosedCessna 172A · Farmersburg, INJun 23, 1964 · N6982A · Destroyed NTSB UNK64X2316Accident · Minor injuriesClosedCessna 172 · Van Buren, INJun 16, 1964 · N6498E · Substantial damage