NTSB investigations: Cessna 172H, OR

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

19672026

NTSB investigations: Cessna 172H, OR per year, 1967–2026: 9 cases
1967	3
1968	2
1970	1
1972	1
1992	1
2005	1

Where

Open the map

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" = 'OR' 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 ('2072424')) 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\" = 'OR' 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 ('2072424'))
  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" = 'OR' 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 ('2072424'))
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 SEA05CA055Accident · Minor injuriesData collectionFinal reportCessna 172H · Waldport, ORThe pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.Mar 6, 2005 · N8100L · Substantial damage NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damage NTSB SEA72DYA34Accident · No injuriesClosedCessna 172H · Ontario, ORMay 13, 1972 · N2626L · 2 aircraft · Substantial damage NTSB SEA71DVQ11Accident · Serious injuriesClosedCessna 172H · Ashland, ORSep 5, 1970 · N3783R · Destroyed NTSB SEA69D0077Accident · Minor injuriesClosedCessna 172H · Union Creek, ORJul 18, 1968 · N8829Z · Destroyed NTSB SEA69D0044Accident · No injuriesClosedCessna 172 · Ashland, ORMar 29, 1968 · N1718F · Substantial damage NTSB SEA68F0228Accident · No injuriesClosedCessna 172 · Yamhill, OROct 16, 1967 · N1621F · Substantial damage NTSB SEA68F0206Accident · No injuriesClosedCessna 172 · Newberg, OROct 11, 1967 · N3843R · Substantial damage NTSB SEA68D0102Accident · No injuriesClosedCessna 172 · Gates, ORAug 7, 1967 · N3739F · Substantial damage