NTSB investigations: Cessna 172I, MO

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

19702026

NTSB investigations: Cessna 172I, MO per year, 1970–2026: 8 cases
1970	1
1974	1
1977	2
1981	1
1985	1
1987	1
1993	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" = 'MO' 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 ('2072426')) 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\" = 'MO' 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 ('2072426'))
  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" = 'MO' 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 ('2072426'))
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 CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.Nov 9, 1993 · N35537 · Substantial damage NTSB MKC88LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Sweet Springs, MODuring a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…Nov 2, 1987 · N46094 · Substantial damage NTSB MKC85LA222Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Cameron, MOThe pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to…Sep 21, 1985 · N46175 · Substantial damage NTSB MKC82FA011Accident · No injuriesClosedCessna 172 · Kansas City, MODec 11, 1981 · N35672 · Substantial damage NTSB MKC77FCG53Accident · Minor injuriesClosedCessna 172I · Lebanon, MOSep 8, 1977 · N46137 · Substantial damage NTSB MKC77FCA24Accident · Minor injuriesClosedCessna 172 · South Argyle, MOJun 5, 1977 · N35555 · Substantial damage NTSB MKC75FCA14Accident · Minor injuriesClosedCessna 172 · Wellsville, MOOct 21, 1974 · N566QL · Substantial damage NTSB MKC71AK015Accident · 2 fatalClosedCessna 172I · Vichy, MOSep 13, 1970 · N46223 · Destroyed