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 MKC80FA044Accident · No injuriesClosedCessna P210N · Winfield, KSJul 14, 1980 · N731XK · Destroyed NTSB MKC80DCQ23Accident · No injuriesClosedPiper PA-32 · Kiowa, KSJul 1, 1980 · N3532W · Substantial damage NTSB MKC80DCQ24Accident · Minor injuriesClosedCessna 210P · Pratt, KSJun 30, 1980 · N3761P · Substantial damage NTSB MKC80FCQ22Accident · Minor injuriesClosedCessna 150L · Mcpherson, KSJun 24, 1980 · N11319 · Destroyed NTSB MKC80DCQ21Accident · No injuriesClosedPiper PA-36 · Kanorado, KSJun 23, 1980 · N9933P · Substantial damage NTSB MKC80DCQ20Accident · No injuriesClosedCessna 172 · Coldwater, KSJun 16, 1980 · N1297F · Substantial damage NTSB MKC80FCQ19Accident · 1 fatalClosedBenchmark 01 · Newton, KSJun 8, 1980 · N79FG · Destroyed NTSB MKC80FA040Accident · Serious injuriesClosedCessna 337B · Olathe, KSJun 5, 1980 · N2323S · Destroyed NTSB MKC80DCG24Accident · No injuriesClosedCessna 206 · Atchinson, KSJun 3, 1980 · N8611Z · Substantial damage NTSB MKC80FA038Accident · 4 fatalClosedPiper PA-28 · Brookville, KSJun 1, 1980 · N9594K · Destroyed NTSB MKC80DCQ18Accident · No injuriesClosedCessna 172 · Quinter, KSMay 31, 1980 · N73069 · Substantial damage NTSB MKC80DCG23Accident · No injuriesClosedPiper PA-28 · Perry, KSMay 25, 1980 · N2870X · Substantial damage NTSB MKC80FA034Accident · 1 fatalClosedPitts S2S · Olathe, KSMay 7, 1980 · N22EL · Destroyed NTSB MKC80FCQ14Accident · Minor injuriesClosedBucker Jung BU131 · Colwich, KSMay 4, 1980 · N80424 · Substantial damage NTSB MKC80DCQ16Accident · No injuriesClosedBeech 23 · Beaumont, KSMay 4, 1980 · N9150S · Substantial damage NTSB MKC80FCQ15Accident · No injuriesClosedPiper PA-34 · Hays, KSMay 2, 1980 · N47347 · Substantial damage NTSB MKC80FCQ13Accident · Serious injuriesClosedCessna A188B · Winfield, KSApr 23, 1980 · N4760Q · Substantial damage NTSB MKC80DCG20Accident · No injuriesClosedGrumman AA1B · Lebo, KSApr 21, 1980 · N1425R · Substantial damage NTSB MKC80FCQ12Accident · No injuriesClosedBalloon WKS FF7 · Towanda, KSApr 18, 1980 · N2033F · Substantial damage NTSB MKC80FA031Accident · No injuriesClosedCessna 207 · Mclouth, KSApr 18, 1980 · N1568U · Substantial damage NTSB MKC80DCQ11Accident · No injuriesClosedGrumman G-164C · Strauss, KSApr 7, 1980 · N6770K · Substantial damage NTSB MKC80FCG18Accident · No injuriesClosedPiper PA-44 · Olathe, KSApr 2, 1980 · N21399 · Substantial damage NTSB MKC80DCG15Accident · No injuriesClosedCessna 210 · Olathe, KSMar 12, 1980 · N7317A · Substantial damage NTSB MKC80FCQ10Accident · No injuriesClosedCessna 182RG · Council Grove, KSFeb 19, 1980 · N7325X · Substantial damage NTSB MKC80FA023Accident · 1 fatalClosedBeech H18 · Olathe, KSFeb 15, 1980 · N729F · Destroyed NTSB MKC80DCG12Accident · No injuriesClosedCessna 150 · Sabetha, KSFeb 11, 1980 · N7191G · Substantial damage NTSB MKC80FCG10Accident · No injuriesClosedCessna 150L · Ft.Leavenworth, KSFeb 3, 1980 · N1490Q · Substantial damage NTSB MKC80FA018Accident · 1 fatalClosedCessna 150 · Newton, KSJan 19, 1980 · N51274 · Destroyed NTSB MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSDec 23, 1979 · N7253M · Destroyed NTSB MKC80FA016Accident · 1 fatalClosedCessna 150G · Anthony, KSDec 22, 1979 · N8409J · Destroyed NTSB MKC80FA015Accident · 1 fatalClosedCessna 152 · Olathe, KSDec 21, 1979 · N25494 · Destroyed NTSB MKC80DCQ09Accident · No injuriesClosedCessna 210 · Hutchinson, KSDec 21, 1979 · N5470C · Substantial damage NTSB MKC80DCQ08Accident · No injuriesClosedCessna 170B · Kingman, KSDec 20, 1979 · N3050A · Substantial damage NTSB MKC80FCQ07Accident · No injuriesClosedPiper PA-32 · Cedar Vale, KSDec 15, 1979 · N2162E · Substantial damage NTSB MKC80FCQ08Accident · No injuriesClosedPiper PA-34 · Osawatomie, KSDec 14, 1979 · N2078N · Substantial damage NTSB MKC80DCQ06Accident · No injuriesClosedCessna 182 · Glasco, KSDec 13, 1979 · N5113D · Substantial damage NTSB MKC80FCQ05Accident · Minor injuriesClosedCessna 150G · Onaga, KSDec 9, 1979 · N3165X · Substantial damage NTSB MKC80FCQ04Accident · Minor injuriesClosedPiper PA-28 · Dodge City, KSDec 9, 1979 · N5298S · Substantial damage NTSB MKC80FCQ03Accident · No injuriesClosedHughes 269C · Garden City, KSDec 4, 1979 · N7481F · Substantial damage NTSB MKC80FCG06Accident · Serious injuriesClosedBeech B-95 · Leawood, KSDec 3, 1979 · N2781Y · Substantial damage NTSB MKC80FA009Accident · 1 fatalClosedMooney M-20J · Coffeyville, KSNov 23, 1979 · N201UP · Destroyed NTSB MKC79FA006Accident · 1 fatalClosedPazmany PL-2 · Olathe, KSNov 16, 1979 · N72KA · Minor damage NTSB MKC79DCQ01Accident · No injuriesClosedBeech 100 · Hutchinson, KSOct 14, 1979 · YV125CP · Substantial damage NTSB MKC80FCQ02Accident · No injuriesClosedAiryplane PDQ · Lyons, KSOct 12, 1979 · N1053E · Substantial damage NTSB MKC79DCQ47Accident · No injuriesClosedPiper PA-28 · Goodland, KSSep 27, 1979 · N6484W · Substantial damage NTSB MKC79FA056Accident · Minor injuriesClosedPiper PA-28 · Chanute, KSSep 20, 1979 · N6146H · Substantial damage NTSB MKC79DCQ45Accident · No injuriesClosedCessna 210 · Wichita, KSSep 18, 1979 · N732PY · Substantial damage NTSB MKC79DCQ46Accident · No injuriesClosedCessna 172 · Wichita, KSSep 16, 1979 · N2234E · Substantial damage NTSB MKC79FA051Accident · 2 fatalClosedCessna 210L · Garden City, KSSep 5, 1979 · N59200 · Destroyed NTSB MKC79DCQ44Accident · No injuriesClosedBeech C23 · Newton, KSSep 4, 1979 · N2007L · Substantial damage