Skip to content

NTSB investigations: Cessna 172, AL

18 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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.Aug 2, 2001 · N7006A · Substantial damage NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.Nov 30, 2000 · N8507B · Substantial damage NTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.Mar 26, 1999 · N8968B · Substantial damage NTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.Jan 12, 1999 · N6700A · Substantial damage NTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.Jun 16, 1993 · N8322B · Substantial damage NTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.Jun 23, 1989 · N70RS · Substantial damage NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…Dec 20, 1984 · N4093F · Destroyed NTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALAug 31, 1981 · N7006A · Substantial damage NTSB MIA78DKJ50Accident · Minor injuriesClosedCessna 172 · Huntsville, ALJun 12, 1978 · N6136E · Substantial damage NTSB MIA77FKJ88Accident · Serious injuriesClosedCessna 172 · Weaver, ALAug 31, 1977 · N8302B · Substantial damage NTSB MIA75FKJ42Accident · No injuriesClosedCessna 172 · Columbia, ALFeb 8, 1975 · N6238E · Substantial damage NTSB MIA70D0164Accident · No injuriesClosedCessna 172 · Gadsden, ALSep 29, 1969 · N8302B · Substantial damage NTSB MIA69F0327Accident · No injuriesClosedCessna 172 · Enterprise, ALJan 26, 1969 · N8822B · Substantial damage NTSB MIA69F0193Accident · No injuriesClosedCessna 172 · Clopton, ALSep 27, 1968 · N8822B · Substantial damage NTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damage NTSB MIA65A0105Accident · 2 fatalClosedCessna 172 · Evergreen, ALApr 24, 1965 · N8004B · Destroyed NTSB UNK64X2521Accident · No injuriesClosedCessna 172 · Gadsen, ALJun 27, 1964 · N7300A · Substantial damage