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 MKC67D0232Accident · No injuriesClosedCessna 150E · Hays, KSAug 25, 1966 · N3028J · Substantial damage NTSB MKC67D0227Accident · No injuriesClosedCessna 150 · Wellington, KSAug 24, 1966 · N6721F · Substantial damage NTSB MKC67F0196Accident · No injuriesClosedPiper PA-24 · Leawood, KSAug 21, 1966 · N8188P · Substantial damage NTSB MKC67D0162Accident · No injuriesClosedCessna 150 · Kansas City, KSAug 17, 1966 · N7842F · Substantial damage NTSB MKC67D0123Accident · No injuriesClosedBeech A23 · Goddard, KSAug 15, 1966 · N8775M · Substantial damage NTSB MKC67F0194Accident · No injuriesClosedMooney M20E · Kansas City, KSAug 13, 1966 · N5548Q · Substantial damage NTSB MKC67D0114Accident · No injuriesClosedCessna 150 · Mulvane, KSAug 5, 1966 · N7381X · Substantial damage NTSB MKC67A0010Accident · 2 fatalClosedPiper PA-20 · Kingsdown, KSAug 5, 1966 · N7602K · Destroyed NTSB MKC67A0009Accident · 4 fatalClosedPiper PA-24 · Hunter, KSAug 5, 1966 · N6161P · Destroyed NTSB MKC67D0163Accident · No injuriesClosedCessna 150 · El Dorado, KSAug 2, 1966 · N8101F · Substantial damage NTSB MKC67D0222Accident · No injuriesClosedCessna 182 · Leawood, KSJul 31, 1966 · N3187Y · Substantial damage NTSB MKC67F0153Accident · No injuriesClosedBeech A23 · Wichita, KSJul 30, 1966 · N2319W · Substantial damage NTSB MKC67D0133Accident · No injuriesClosedPiper PA-30 · Olathe, KSJul 21, 1966 · N260K · Substantial damage NTSB MKC67F0060Accident · No injuriesClosedBoeing A75N1 · Mcdonald, KSJul 19, 1966 · N69656 · Substantial damage NTSB MKC67F0135Accident · No injuriesClosedBoeing A75N1 · Newton, KSJul 18, 1966 · N53232 · Substantial damage NTSB MKC67F0083Accident · No injuriesClosedErcoupe 415-C · Tribune, KSJul 17, 1966 · N99504 · Destroyed NTSB MKC67D0099Accident · No injuriesClosedCessna 175 · Ness City, KSJul 17, 1966 · N6773E · Substantial damage NTSB MKC67D0139Accident · No injuriesClosedMooney M20E · Portis, KSJul 12, 1966 · N79329 · Substantial damage NTSB MKC67D0068Accident · No injuriesClosedAeronca 7AC · Junction City, KSJul 12, 1966 · N3521E · Substantial damage NTSB MKC67D0071Accident · Minor injuriesClosedPiper PA-22 · Pittsburg, KSJul 10, 1966 · N5701D · Substantial damage NTSB MKC67F0231Accident · No injuriesClosedBoeing A75N1 · Salina, KSJul 8, 1966 · N50166 · Destroyed NTSB MKC67F0052Accident · Minor injuriesClosedCessna 150D · Bonner Sprgs, KSJul 6, 1966 · N4410U · Substantial damage NTSB MKC67F0104Accident · Minor injuriesClosedEmigh A-2 · Wichita, KSJul 5, 1966 · N8347H · Substantial damage NTSB MKC67D0115Accident · Minor injuriesClosedPiper PA-22 · Cheney, KSJul 5, 1966 · N5680Z · Substantial damage NTSB MKC67D0048Accident · No injuriesClosedBeech 23 · Leawood, KSJul 4, 1966 · N2378J · Substantial damage NTSB MKC67D0030Accident · No injuriesClosedCessna 150 · Lawrence, KSJul 4, 1966 · N1140Y · Substantial damage NTSB MKC67D0216Accident · No injuriesClosedBeech 35-C33 · Wichita, KSJun 28, 1966 · N6103V · Substantial damage NTSB MKC67D0074Accident · No injuriesClosedMooney M21 · Kansas City, KSJun 28, 1966 · N6786U · Substantial damage NTSB MKC67F0131Accident · No injuriesClosedPiper PA-22 · Topeka, KSJun 27, 1966 · N7159D · Substantial damage NTSB MKC67D0188Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 25, 1966 · N7392P · Substantial damage NTSB MKC67D0059Accident · No injuriesClosedPiper PA-32 · Hugoton, KSJun 19, 1966 · N3481W · Substantial damage NTSB MKC66A0067Accident · 1 fatalClosedMooney M20C · Kansas City, KSJun 17, 1966 · N6211U · Destroyed NTSB MKC67D0134Accident · No injuriesClosedBeech 95-A55 · Manhattan, KSJun 16, 1966 · N1522Z · Substantial damage NTSB MKC67D0090Accident · No injuriesClosedChampion 7GC · Hanover, KSJun 14, 1966 · N9827Y · Substantial damage NTSB MKC66D0586Accident · No injuriesClosedBoeing A75 · Berryton, KSJun 13, 1966 · N73357 · Destroyed NTSB MKC67D0219Accident · No injuriesClosedPiper PA-18 · Buffalo, KSJun 10, 1966 · N9470D · Substantial damage NTSB MKC67D0089Accident · No injuriesClosedCessna 182 · Larned, KSJun 8, 1966 · N3779U · Substantial damage NTSB MKC67F0073Accident · Minor injuriesClosedPiper PA-28 · Kansas City, KSMay 30, 1966 · N6686W · Substantial damage NTSB MKC67D0045Accident · No injuriesClosedMooney M20C · Wellington, KSMay 29, 1966 · N6460U · Substantial damage NTSB MKC66D0579Accident · No injuriesClosedPiper PA-30 · Lawrence, KSMay 26, 1966 · N7898Y · Substantial damage NTSB MKC67F0005Accident · Minor injuriesClosedPiper PA-28 · Wichita, KSMay 24, 1966 · N6410W · Destroyed NTSB MKC67D0029Accident · No injuriesClosedBeech 35-C33 · Garden City, KSMay 20, 1966 · N1512Z · Substantial damage NTSB MKC66D0594Accident · No injuriesClosedCessna 150 · Emporia, KSMay 18, 1966 · N6063T · Substantial damage NTSB MKC66D0565Accident · No injuriesClosedAlon A-2 · Topeka, KSMay 14, 1966 · N6578Q · Substantial damage NTSB MKC66F0562Accident · No injuriesClosedCessna 150 · Kansas City, KSMay 12, 1966 · N6725F · Substantial damage NTSB MKC66D0595Accident · Minor injuriesClosedBeech M35 · Marysville, KSMay 6, 1966 · N9735R · Destroyed NTSB MKC66F0516Accident · No injuriesClosedChampion 7HC · Stanley, KSMay 1, 1966 · N1030Z · Substantial damage NTSB MKC67D0033Accident · No injuriesClosedCessna 210-5 · Wichita, KSApr 23, 1966 · N1817Z · Substantial damage NTSB MKC66F0563Accident · Minor injuriesClosedCessna 172 · Neodesha, KSApr 17, 1966 · N5638R · Substantial damage NTSB MKC66F0552Accident · No injuriesClosedMooney M20 · Kingman, KSApr 16, 1966 · N853B · Substantial damage