Skip to content

NTSB investigations, KS

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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" = 'KS' AND c."eventCountry" = 'USA' 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\" = 'KS' AND c.\"eventCountry\" = 'USA'
  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" = 'KS' AND c."eventCountry" = 'USA'
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 UNK64X3125Accident · No injuriesClosedAir Product F1 · Winona, KSJul 30, 1964 · N3052G · Substantial damage NTSB UNK64X3087Accident · No injuriesClosedBeechcraft 35 · Ulysses, KSJul 28, 1964 · N3211V · Substantial damage NTSB UNK64X2958Accident · No injuriesClosedPiper PA28 · Gardner, KSJul 21, 1964 · N7011W · Substantial damage NTSB UNK64X2952Accident · Serious injuriesClosedBrantly B2 · Wichita, KSJul 21, 1964 · N4995C · Substantial damage NTSB UNK64X2899Accident · No injuriesClosedPiper PA22 · Topeka, KSJul 18, 1964 · N5035Z · Substantial damage NTSB UNK64X2863Accident · No injuriesClosedPiper PA22 · Junction City, KSJul 16, 1964 · N8620C · Destroyed NTSB UNK64X2841Accident · No injuriesClosedBoeing A75 · Norton, KSJul 15, 1964 · N61359 · Substantial damage NTSB UNK64X2770Accident · No injuriesClosedMooney MK18 · Medicine Lodge Ka, KSJul 11, 1964 · N4160 · Substantial damage NTSB UNK64X2569Accident · No injuriesClosedPiper PA28 · Moundridge, KSJun 29, 1964 · N5332W · Substantial damage NTSB UNK64X2482Accident · No injuriesClosedPiper PA22 · Olpe, KSJun 25, 1964 · N7804D · Substantial damage NTSB UNK64X2476Accident · No injuriesClosedPiper PA18A · Oberlin, KSJun 25, 1964 · N9252D · Substantial damage NTSB UNK64X2458Accident · No injuriesClosedCessna 150C · Wichita, KSJun 24, 1964 · N7974Z · Destroyed NTSB UNK64X2387Accident · No injuriesClosedBeechcraft 33 · Attica, KSJun 20, 1964 · N9592Y · Substantial damage NTSB UNK64X2385Accident · No injuriesClosedPiper PA22 · Satanta, KSJun 20, 1964 · N3735A · Substantial damage NTSB UNK64X2381Accident · 1 fatalClosedCessna 172B · Quinter, KSJun 19, 1964 · N8130X · Destroyed NTSB UNK64X2371Accident · No injuriesClosedCessna 140 · Santanta, KSJun 19, 1964 · N2367V · Destroyed NTSB UNK64X2306Accident · No injuriesClosedBeechcraft 33 · Hugoton, KSJun 15, 1964 · N624V · Substantial damage NTSB UNK64X2263Accident · Minor injuriesClosedCessna 172C · Severance, KSJun 13, 1964 · N1343Y · Substantial damage NTSB UNK64X2257Accident · Minor injuriesClosedCessna 150 · Akkansas Cty, KSJun 13, 1964 · N7252K · Destroyed NTSB UNK64X2251Accident · No injuriesClosedMooney M20 · Bucklin, KSJun 12, 1964 · N6020X · Substantial damage NTSB UNK64X2155Accident · No injuriesClosedCessna 170B · Newton, KSJun 6, 1964 · N4542C · Substantial damage NTSB UNK64X2114Accident · No injuriesClosedLear M23 · Wichita, KSJun 4, 1964 · N801L · Destroyed NTSB UNK64X2092Accident · No injuriesClosedPiper PA18 · Overbrook, KSJun 3, 1964 · N8887D · Destroyed NTSB UNK64X2081Accident · No injuriesClosedStinson 1083 · Atchison, KSJun 3, 1964 · N830C · Substantial damage NTSB UNK64X2067Accident · Minor injuriesClosedCessna 150C · Medora, KSJun 2, 1964 · N7882Z · Substantial damage NTSB UNK64X1940Accident · No injuriesClosedCessna 170A · Rosehill, KSMay 24, 1964 · N9055A · Substantial damage NTSB UNK64X1934Accident · Minor injuriesClosedLuscombe 8E · Gardner, KSMay 24, 1964 · N2306K · Substantial damage NTSB UNK64X1923Accident · No injuriesClosedCessna 172D · Pratt, KSMay 23, 1964 · N2420U · Substantial damage NTSB UNK64X1880Accident · No injuriesClosedAeronca 7AC · Syracuse, KSMay 22, 1964 · N84795 · Substantial damage NTSB UNK64X1820Accident · No injuriesClosedPiper PA22 · El Dorado, KSMay 18, 1964 · N892A · Substantial damage NTSB UNK64X1755Accident · No injuriesClosedCessna 172 · El Dorado, KSMay 13, 1964 · N6938A · Substantial damage NTSB UNK64X1740Accident · No injuriesClosedPiper PA24 · Manhattan, KSMay 12, 1964 · N6544P · Substantial damage NTSB UNK64X1730Accident · Serious injuriesClosedPiper PA24 · Severance, KSMay 11, 1964 · N5135P · Substantial damage NTSB UNK64X1726Accident · No injuriesClosedPiper PA18 · Chanute, KSMay 11, 1964 · N4485A · Substantial damage NTSB UNK64X1703Accident · Minor injuriesClosedPiper PA-28 · Marysville, KSMay 10, 1964 · N8755W · Substantial damage NTSB UNK64X1668Accident · No injuriesClosedCessna 170B · Topeka, KSMay 8, 1964 · N3400C · Substantial damage NTSB UNK64X1649Accident · No injuriesClosedHiller UH12A · Abilene, KSMay 7, 1964 · N10172 · Substantial damage NTSB UNK64X1648Accident · 4 fatalClosedPiper PA28 · Wichita, KSMay 7, 1964 · N7221W · Destroyed NTSB UNK64X1643Accident · No injuriesClosedCessna 172A · Garden City, KSMay 7, 1964 · N7452T · Substantial damage NTSB UNK64X1568Accident · Serious injuriesClosedCessna 170 · Bonner Spgs, KSMay 2, 1964 · N2627V · Destroyed NTSB UNK64X1510Accident · No injuriesClosedCessna 195A · Valley Center, KSApr 29, 1964 · N1560D · Substantial damage NTSB UNK64X1456Accident · 1 fatalClosedPitts Spec · Leoti, KSApr 25, 1964 · N11J · Destroyed NTSB UNK64X1427Accident · Serious injuriesClosedBeechcraft 35B33 · El Dorado, KSApr 23, 1964 · N904Q · Destroyed NTSB UNK64X1416Accident · 3 fatalClosedBeechcraft B95 · Colby, KSApr 22, 1964 · N9979R · Destroyed NTSB UNK64X1379Accident · No injuriesClosedPiper J3F · Tola, KSApr 19, 1964 · N35877 · Substantial damage NTSB UNK64X1317Accident · No injuriesClosedPiper PA22 · Topeka, KSApr 14, 1964 · N5035Z · Substantial damage NTSB UNK64X1265Accident · No injuriesClosedPiper PA20 · Hays, KSApr 11, 1964 · N7475K · Substantial damage NTSB UNK64X1249Accident · No injuriesClosedPiper PA24 · Topeka, KSApr 10, 1964 · N5495P · Substantial damage NTSB UNK64X1181Accident · Minor injuriesClosedSchweizer 119A · Dodge City, KSApr 5, 1964 · N40278 · Substantial damage NTSB UNK64X1136Accident · No injuriesClosedBeechcraft 23 · El Dorado, KSApr 2, 1964 · N2367J · Substantial damage