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 MKC66D0299Accident · No injuriesClosedPiper PA-28 · Wichita, KSOct 23, 1965 · N8746W · Substantial damage NTSB MKC66F0275Accident · No injuriesClosedMooney M20C · Carbondale, KSOct 17, 1965 · N1374W · Substantial damage NTSB MKC66D0310Accident · No injuriesClosedLuscombe 8A · Coffeyville, KSOct 9, 1965 · N71368 · Substantial damage NTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSOct 9, 1965 · N76939 · Substantial damage NTSB MKC66F0354Accident · No injuriesClosedPiper PA-28 · Mcpherson, KSOct 8, 1965 · N5332W · Substantial damage NTSB MKC66F0264Accident · No injuriesClosedCessna 310I · Wichita, KSOct 5, 1965 · N8037M · Substantial damage NTSB MKC66D0282Accident · No injuriesClosedCessna 180 · Oakley, KSOct 3, 1965 · N1638C · Substantial damage NTSB MKC66A0021Accident · 1 fatalClosedCessna 188 · Wichita, KSSep 28, 1965 · N3756C · Destroyed NTSB MKC66F0232Accident · Serious injuriesClosedChampion 7FC · Bonner Sprgs, KSSep 26, 1965 · N7580E · Substantial damage NTSB MKC66F0262Accident · No injuriesClosedPiper PA-24 · Wichita, KSSep 25, 1965 · N6839P · Substantial damage NTSB NYC66F0224Accident · Minor injuriesClosedCessna 150F · Gardner, KSSep 18, 1965 · N8257S · Substantial damage NTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSSep 11, 1965 · N3604V · Substantial damage NTSB MKC66A0017Accident · 4 fatalClosedBeechcraft B-95 · Newton, KSSep 11, 1965 · N9695Y · Destroyed NTSB MKC66F0247Accident · No injuriesClosedPiper PA-22 · Atchison, KSSep 7, 1965 · N2438P · Substantial damage NTSB MKC66D0274Accident · No injuriesClosedCessna 150 · Lacygne, KSSep 6, 1965 · N4203U · Substantial damage NTSB MKC66F0246Accident · No injuriesClosedCallair A-5 · Munden, KSSep 4, 1965 · N9956C · Substantial damage NTSB MKC66D0212Accident · No injuriesClosedCessna 180 · Maize, KSSep 4, 1965 · N1577C · Substantial damage NTSB MKC66F0223Accident · No injuriesClosedBeechcraft 23 · Wichita, KSSep 1, 1965 · N2347Z · Substantial damage NTSB MKC66A0014Accident · 2 fatalClosedBeech M35 · Hutchinson, KSAug 31, 1965 · N9731R · Destroyed NTSB MKC66F0204Accident · No injuriesClosedStinson 108-1 · Derby, KSAug 28, 1965 · N97048 · Substantial damage NTSB MKC66F0193Accident · No injuriesClosedMooney M-20 · Kingman, KSAug 27, 1965 · N853B · Substantial damage NTSB MKC66F0173Accident · No injuriesClosedCessna 210E · Wichita, KSAug 26, 1965 · N2312F · Substantial damage NTSB MKC66F0177Accident · No injuriesClosedCessna 180 · Wichita, KSAug 25, 1965 · N2915C · Substantial damage NTSB MKC66A0010Accident · Serious injuriesClosedBoeing B-720B · Leavenworth, KSAug 17, 1965 · N57202 · No damage NTSB MKC66F0167Accident · No injuriesClosedCessna 172 · Wichita, KSAug 15, 1965 · N5945A · Substantial damage NTSB MKC66D0172Accident · Minor injuriesClosedCessna 210 · Ottawa, KSAug 15, 1965 · N9488X · Substantial damage NTSB MKC66F0155Accident · No injuriesClosedCessna 182H · Leawood, KSAug 13, 1965 · N8334S · Substantial damage NTSB MKC66F0171Accident · No injuriesClosedPiper PA-24 · Wichita, KSAug 6, 1965 · N8056P · Substantial damage NTSB MKC66F0120Accident · No injuriesClosedAeronca 7DC · Hill City, KSJul 29, 1965 · N2525E · Substantial damage NTSB MKC66F0110Accident · No injuriesClosedBeechcraft B-50 · Emporia, KSJul 25, 1965 · N3597B · Substantial damage NTSB MKC66A0006Accident · No injuriesClosedBell 47D-1 · Wichita, KSJul 24, 1965 · N9713C · Destroyed NTSB MKC66F0143Accident · No injuriesClosedPiper PA-28 · Kansas City, KSJul 22, 1965 · N6110W · Substantial damage NTSB MKC66F0109Accident · No injuriesClosedLear Jet 23 · Wichita, KSJul 21, 1965 · N388R · Substantial damage NTSB MKC66F0096Accident · No injuriesClosedCessna 210E · Mccracken, KSJul 19, 1965 · N2312F · Substantial damage NTSB MKC66D0103Accident · No injuriesClosedCessna 182 · Gardner, KSJul 17, 1965 · N8412T · Substantial damage NTSB MKC66F0141Accident · Minor injuriesClosedBoeing E75 · Dodge City, KSJul 6, 1965 · N5353N · Destroyed NTSB MKC66A0001Accident · 1 fatalClosedPiper PA-18 · Goodland, KSJul 3, 1965 · N3588Z · Destroyed NTSB MKC65A0079Accident · 1 fatalClosedPiper PA-18 · Modoc, KSJun 26, 1965 · N4055Z · Destroyed NTSB MKC66F0044Accident · Minor injuriesClosedLuscombe 8E · Colwich, KSJun 23, 1965 · N1851K · Destroyed NTSB MKC66D0101Accident · Serious injuriesClosedBoeing N2S-3 · Friend, KSJun 23, 1965 · N61444 · Destroyed NTSB MKC66F0069Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 20, 1965 · N8546P · Substantial damage NTSB MKC66F0059Accident · No injuriesClosedPiper PA-25 · Hays, KSJun 19, 1965 · N6528Z · Substantial damage NTSB MKC66F0056Accident · No injuriesClosedPiper PA-24 · Dodge City, KSJun 18, 1965 · N5944F · Substantial damage NTSB MKC65A0076Accident · No injuriesClosedLearjet 23 · Wichita, KSJun 14, 1965 · N802L · Substantial damage NTSB MKC66D0063Accident · No injuriesClosedPiper PA-22 · Topeka, KSJun 13, 1965 · N5035Z · Substantial damage NTSB MKC66F0034Accident · Minor injuriesClosedBeechcraft 35-33 · Wichita, KSJun 5, 1965 · N303Z · Substantial damage NTSB MKC66F0024Accident · No injuriesClosedGrumman G-164 · Manhattan, KSJun 3, 1965 · N692Y · Substantial damage NTSB MKC66F0019Accident · No injuriesClosedErcoupe 415C · Wellington, KSJun 3, 1965 · N87131 · Substantial damage NTSB MKC66F0011Accident · No injuriesClosedPiper PA-28 · Salina, KSMay 30, 1965 · N5553W · Substantial damage NTSB MKC65F0143Accident · Minor injuriesClosedPiper PA-20 · Emporia, KSMay 26, 1965 · N1560A · Destroyed