NTSB investigations: Cessna 170A, MO

10 cases on aircraft the registry lists as Cessna 170A. 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

19662026

NTSB investigations: Cessna 170A, MO per year, 1966–2026: 10 cases
1966	1
1967	1
1970	1
1971	1
1974	1
1979	1
2002	1
2008	1
2009	1
2021	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 ('2072304')) 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 ('2072304'))
  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 ('2072304'))
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 CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…Mar 9, 2021 · N9515A · Substantial damage NTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Sep 6, 2009 · N9129A · Substantial damage NTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.Oct 24, 2008 · N5773C · Substantial damage NTSB CHI02LA096Accident · No injuriesLimited investigationFinal reportCessna 170A · Gainesville, MOThe pilot's misjudgment of distance/altitude and his failure to perform a go-around.Mar 22, 2002 · N170PS · Substantial damage NTSB MKC79FCA06Accident · Minor injuriesClosedCessna 170A · Hillsboro, MOJan 2, 1979 · N9951A · Substantial damage NTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MOJul 5, 1974 · N9734A · Substantial damage NTSB MKC72DCG08Accident · No injuriesClosedCessna 170A · Gainsville, MOJul 28, 1971 · N9087A · Substantial damage NTSB MKC71AK004Accident · 1 fatalClosedCessna 170A · Elmo, MOJul 23, 1970 · N1340D · Destroyed NTSB MKC68F0186Accident · Serious injuriesClosedCessna 170A · Thompson, MOAug 23, 1967 · N6144U · Destroyed NTSB MKC67F0288Accident · No injuriesClosedCessna 170 · Ft.L.Wood, MOOct 27, 1966 · N5728C · Substantial damage