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 MKC69D0108Accident · No injuriesClosedPiper PA-18A · Concordia, KSAug 3, 1968 · N4891A · Destroyed NTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSAug 2, 1968 · N8086V · Substantial damage NTSB MKC69A0006Accident · 1 fatalClosedPiper PA-28 · Ness City, KSJul 28, 1968 · N5148L · Destroyed NTSB MKC69A0005Accident · 3 fatalClosedMooney M20G · Phillipsburg, KSJul 24, 1968 · N6850N · Destroyed NTSB MKC69D0062Accident · Minor injuriesClosedPiper PA-28 · Summerfield, KSJul 14, 1968 · N7519R · Substantial damage NTSB MKC69D0173Accident · Minor injuriesClosedTaylorcraft BC12-D · Lacygne, KSJul 13, 1968 · N96438 · Substantial damage NTSB MKC69D0204Accident · No injuriesClosedErco 415-C · Stilwell, KSJul 1, 1968 · N93624 · Substantial damage NTSB MKC69F0356Accident · No injuriesClosedCessna 175A · Burdett, KSJun 28, 1968 · N6773E · Substantial damage NTSB MKC69F0060Accident · No injuriesClosedBell 47G · Garden City, KSJun 25, 1968 · N163B · Substantial damage NTSB MKC69D0021Accident · No injuriesClosedCessna 150 · Eureka, KSJun 23, 1968 · N7736F · Substantial damage NTSB FTW69F0040Accident · Serious injuriesClosedPiper PA-25 · Elkhart, KSJun 23, 1968 · N6710Z · Destroyed NTSB MKC68D0603Accident · No injuriesClosedCessna 150 · Derby, KSJun 21, 1968 · N8568J · Substantial damage NTSB MKC68F0602Accident · No injuriesClosedCessna 177 · Ulysses, KSJun 18, 1968 · N2865X · Substantial damage NTSB MKC68A0072Accident · 2 fatalClosedPiper PA-22 · Topeka, KSJun 18, 1968 · N1535P · Destroyed NTSB MKC69D0055Accident · No injuriesClosedCessna 182 · Leawood, KSJun 15, 1968 · N2659G · Substantial damage NTSB MKC69D0013Accident · No injuriesClosedCessna 172B · Osborne, KSJun 10, 1968 · N7712X · Substantial damage NTSB MKC69D0033Accident · No injuriesClosedCessna 170B · Mahaska, KSJun 9, 1968 · N3114A · Substantial damage NTSB MKC68A0070Accident · Minor injuriesClosedBellanca 14-193 · Kansas City, KSJun 7, 1968 · N8513R · Substantial damage NTSB MKC68F0588Accident · No injuriesClosedBeech E35 · Coffeyville, KSJun 4, 1968 · N7398B · Substantial damage NTSB MKC69F0046Accident · Minor injuriesClosedCessna 195B · Piper, KSJun 2, 1968 · N2190C · Substantial damage NTSB MKC69F0031Accident · Serious injuriesClosedPiper PA-11 · Lincoln, KSMay 31, 1968 · N78666 · Destroyed NTSB MKC69D0039Accident · Minor injuriesClosedCessna 150H · Oxford, KSMay 29, 1968 · N6502S · Substantial damage NTSB MKC69D0142Accident · No injuriesClosedPiper PA-28 · Osage City, KSMay 28, 1968 · N4505R · Substantial damage NTSB MKC68D0601Accident · No injuriesClosedPiper PA-24 · Wichita, KSMay 27, 1968 · N9158P · Substantial damage NTSB MKC68D0558Accident · No injuriesClosedCallair A-9 · Sublette, KSMay 20, 1968 · N9657Z · Substantial damage NTSB MKC68D0596Accident · No injuriesClosedBeech A23 · Bonner Sprgs, KSMay 18, 1968 · N2390W · Substantial damage NTSB MKC68D0551Accident · No injuriesClosedCessna 140 · Arkansas Cty, KSMay 15, 1968 · N3694V · Substantial damage NTSB MKC69D0044Accident · No injuriesClosedCessna 150 · Bennington, KSMay 8, 1968 · N22732 · Substantial damage NTSB MKC68D0542Accident · No injuriesClosedCessna 150F · Oswego, KSMay 2, 1968 · N8140S · Substantial damage NTSB MKC68D0528Accident · No injuriesClosedCessna 180 · Sublette, KSMay 2, 1968 · N4633A · Substantial damage NTSB MKC68D0519Accident · No injuriesClosedPiper PA-28 · Womer, KSApr 27, 1968 · N7000R · Substantial damage NTSB MKC68D0522Accident · Minor injuriesClosedMooney M20C · Hillsboro, KSApr 24, 1968 · N1399W · Destroyed NTSB MKC68A0062Accident · 4 fatalClosedBeech 35-C33 · Clearwater, KSApr 21, 1968 · N9524Q · Destroyed NTSB MKC68D0562Accident · No injuriesClosedPiper PA-22 · Chanute, KSApr 20, 1968 · N4426A · Substantial damage NTSB MKC68F0594Accident · No injuriesClosedBeech A23A · Maize, KSApr 18, 1968 · N2351W · Substantial damage NTSB MKC68F0510Accident · 1 fatalClosedPr.Prairie SPL 2 · Pr.Prairie, KSApr 14, 1968 · N8635E · Destroyed NTSB MKC68D0540Accident · No injuriesClosedMooney M20F · Russell, KSApr 13, 1968 · N3523X · Substantial damage NTSB MKC68F0548Accident · Serious injuriesClosedPiper PA-28 · Hays, KSApr 11, 1968 · N9153J · Substantial damage NTSB MKC68D0544Accident · No injuriesClosedCessna 150 · Lawrence, KSApr 9, 1968 · N8867G · Substantial damage NTSB MKC68D0525Accident · Minor injuriesClosedHelio H-250 · Leawood, KSApr 7, 1968 · N5464E · Substantial damage NTSB MKC69D0032Accident · No injuriesClosedPiper PA-25 · Selkirk, KSMar 30, 1968 · N7682Z · Substantial damage NTSB MKC68D0541Accident · No injuriesClosedSchweizer SGU222 · Marysville, KSMar 30, 1968 · N3893A · Substantial damage NTSB MKC68D0497Accident · No injuriesClosedBeech A23 · Seneca, KSMar 28, 1968 · N4745J · Substantial damage NTSB MKC68D0502Accident · No injuriesClosedBellanca 14-192 · Moscow, KSMar 25, 1968 · N7601E · Substantial damage NTSB MKC68F0482Accident · Serious injuriesClosedCessna 172 · Dodge City, KSMar 17, 1968 · N8364B · Substantial damage NTSB MKC68F0538Accident · No injuriesClosedDouglas A-26 · Kansas City, KSMar 16, 1968 · N61B · Substantial damage NTSB MKC68F0484Accident · Serious injuriesClosedSnow S2A · Goodland, KSMar 16, 1968 · N9463R · Substantial damage NTSB MKC68D0483Accident · No injuriesClosedCessna 172 · Chanute, KSMar 14, 1968 · N4078F · Substantial damage NTSB MKC68D0480Accident · Minor injuriesClosedCessna 172D · St Marys, KSMar 5, 1968 · N2467Y · Destroyed NTSB MKC68A0055Accident · 2 fatalClosedCessna 177 · Beaumdnt, KSMar 3, 1968 · N2327Y · Destroyed