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 MKC65D0142Accident · No injuriesClosedCessna 182 · Scott City, KSMay 25, 1965 · N3579U · Substantial damage NTSB MKC66F0023Accident · No injuriesClosedCessna 150 · Eureka, KSMay 22, 1965 · N3057J · Substantial damage NTSB MKC66D0078Accident · No injuriesClosedTaylorcraft DC65 · Liberal, KSMay 22, 1965 · N52178 · Substantial damage NTSB MKC66F0072Accident · Minor injuriesClosedCessna 150 · Leawood, KSMay 15, 1965 · N4334U · Destroyed NTSB MKC65F0140Accident · No injuriesClosedStinson 108-1 · Hugoton, KSMay 15, 1965 · N8334K · Substantial damage NTSB MKC66D0020Accident · No injuriesClosedCessna 120 · Big Bow, KSMay 8, 1965 · N2391N · Substantial damage NTSB MKC65F0150Accident · No injuriesClosedPiper J3 · Leoti, KSMay 8, 1965 · N35258 · Substantial damage NTSB MKC65F0144Accident · No injuriesClosedCessna 210A · Pratt, KSMay 5, 1965 · N6597X · Substantial damage NTSB MKC66F0014Accident · No injuriesClosedCessna 180 · Salina, KSApr 30, 1965 · N1638C · Substantial damage NTSB MKC65A0063Accident · No injuriesClosedBell B-47G3 · Dodge City, KSApr 25, 1965 · N8505F · Substantial damage NTSB MKC65F0119Accident · No injuriesClosedMooney M-20 · Leoti, KSApr 19, 1965 · N5234B · Substantial damage NTSB MKC66F0130Accident · No injuriesClosedHoward DGA-15 · Basehor, KSApr 18, 1965 · N9045H · Substantial damage NTSB MKC65F0118Accident · Minor injuriesClosedAeronca 7AC · Lyons, KSApr 13, 1965 · N84180 · Destroyed NTSB MKC65F0109Accident · No injuriesClosedCessna 172 · Hutchinson, KSApr 11, 1965 · N7712X · Substantial damage NTSB MKC65D0116Accident · No injuriesClosedBeechcraft 35-B33 · Newton, KSApr 6, 1965 · N5796K · Substantial damage NTSB MKC66D0010Accident · No injuriesClosedCessna 182 · Paola, KSApr 4, 1965 · N6270A · Substantial damage NTSB MKC65F0083Accident · No injuriesClosedHelio H-250 · Pittsburg, KSApr 3, 1965 · N5444E · Substantial damage NTSB MKC65F0155Accident · No injuriesClosedStinson V-77 · Olathe, KSMar 28, 1965 · N69440 · Substantial damage NTSB MKC65A0055Accident · 4 fatalClosedMooney M-20E · Colby, KSMar 22, 1965 · N6936U · Destroyed NTSB MKC66D0028Accident · No injuriesClosedAeronca 7AC · Kansas City, KSMar 20, 1965 · N84554 · Substantial damage NTSB MKC65A0054Accident · 3 fatalClosedPiper PA-20 · Johnson, KSMar 20, 1965 · N3584A · Destroyed NTSB MKC65F0056Accident · No injuriesClosedMooney 20C · Beloit, KSMar 17, 1965 · N78874 · Substantial damage NTSB MKC65D0057Accident · No injuriesClosedCessna 172F · Topeka, KSMar 17, 1965 · N8583U · Substantial damage NTSB MKC65F0068Accident · Minor injuriesClosedBeechcraft 23 · Wichita, KSMar 12, 1965 · N2321Z · Destroyed NTSB MKC65F0043Accident · No injuriesClosedCessna 172D · Wichita, KSMar 5, 1965 · N2309U · Substantial damage NTSB MKC65A0052Accident · 5 fatalClosedBeechcraft C-45H · Kansas City, KSMar 5, 1965 · N9980Z · Destroyed NTSB MKC65D0123Accident · No injuriesClosedCessna 175 · Olathe, KSMar 2, 1965 · N6597E · Substantial damage NTSB MKC65F0038Accident · Serious injuriesClosedCessna 210 · Scott City, KSFeb 23, 1965 · N7376E · Substantial damage NTSB MKC65F0075Accident · No injuriesClosedPiper PA-20 · Clay Center, KSFeb 21, 1965 · N7305K · Substantial damage NTSB MKC65F0025Accident · No injuriesClosedBellanca 14-19 · Wichita, KSFeb 19, 1965 · N8817R · Substantial damage NTSB MKC65F0045Accident · No injuriesClosedCessna 182 · Concordia, KSFeb 17, 1965 · N8590T · Substantial damage NTSB MKC65F0034Accident · No injuriesClosedCessna 170 · Maize, KSFeb 8, 1965 · N4683C · Substantial damage NTSB MKC65F0147Accident · No injuriesClosedCessna 195 · Olathe, KSFeb 6, 1965 · N4625V · Substantial damage NTSB MKC65F0051Accident · No injuriesClosedBeechcraft A35 · Wichita, KSFeb 6, 1965 · N8752A · Substantial damage NTSB MKC65F0012Accident · No injuriesClosedPiper J3 · Kenesaw, KSJan 30, 1965 · N88037 · Substantial damage NTSB MKC65F0007Accident · No injuriesClosedBeechraft 35 · Wichita, KSJan 25, 1965 · N2736V · Substantial damage NTSB MKC65F0027Accident · No injuriesClosedPiper PA-28 · Sublette, KSJan 24, 1965 · N7985W · Substantial damage NTSB MKC65A0048Accident · 4 fatalClosedBeechcraft K35 · Syracuse, KSJan 22, 1965 · N5390E · Destroyed NTSB MKC65F0005Accident · No injuriesClosedGlobe GC1B · Salina, KSJan 19, 1965 · N90372 · Substantial damage NTSB UNK65X1313Accident · Serious injuriesClosedPiper PA-22 · Viola, KSJan 18, 1965 · N6834B · Substantial damage NTSB MKC65F0060Accident · Serious injuriesClosedAeronca 7AC · Natoma, KSJan 17, 1965 · N2883E · Destroyed NTSB UNK65X1297Accident · 7 fatalClosedBoeing KC-135 · Ichita, KSJan 16, 1965 · USAF501 · Destroyed NTSB MKC65F0024Accident · No injuriesClosedCessna 140 · Sublette, KSJan 15, 1965 · N1121D · Substantial damage NTSB MKC65F0006Accident · No injuriesClosedCessna 337 · Wichita, KSJan 14, 1965 · N2102X · Substantial damage NTSB MKC65F0016Accident · No injuriesClosedBeechraft A23 · Newton, KSJan 11, 1965 · N8766M · Substantial damage NTSB MKC65F0020Accident · Minor injuriesClosedPiper PA-22 · Seneca, KSJan 2, 1965 · N2947Z · Destroyed NTSB MKC65F0001Accident · Minor injuriesClosedAeronca 7AC · Wakeeny, KSJan 1, 1965 · N85485 · Destroyed NTSB MKC65A0045Accident · 2 fatalClosedCessna 172F · Wellington, KSJan 1, 1965 · N8444U · Destroyed NTSB UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSDec 27, 1964 · N7700W · Substantial damage NTSB UNK65X1153Accident · No injuriesClosedCessna 182 · Wichita, KSDec 27, 1964 · N9232X · Substantial damage