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 MKC67A0042Accident · 2 fatalClosedCessna 205 · Dighton, KSJan 1, 1967 · N1881Z · Destroyed NTSB MKC67A0040Accident · 4 fatalClosedBeech A23 · Hoy, KSJan 1, 1967 · N1430L · Destroyed NTSB MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSDec 30, 1966 · N79816 · Destroyed NTSB MKC67D0397Accident · No injuriesClosedPiper PA-28 · Liberal, KSDec 28, 1966 · N8192W · Substantial damage NTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSDec 28, 1966 · N3699D · Substantial damage NTSB MKC67D0415Accident · No injuriesClosedBeech K35 · Great Bend, KSDec 26, 1966 · N3089C · Substantial damage NTSB MKC67F0387Accident · No injuriesClosedPiper PA-23 · Augusta, KSDec 21, 1966 · N2236P · Substantial damage NTSB MKC67D0432Accident · No injuriesClosedMooney M20C · Wichita, KSDec 19, 1966 · N2632W · Substantial damage NTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damage NTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damage NTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damage NTSB MKC67D0533Accident · No injuriesClosedCessna 206 · Kansas City, KSDec 10, 1966 · N2679X · Substantial damage NTSB MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSDec 8, 1966 · N7862F · Substantial damage NTSB MKC67D0343Accident · No injuriesClosedPiper PA-28 · Lawrence, KSDec 3, 1966 · N6265W · Substantial damage NTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSDec 3, 1966 · N8080F · Substantial damage NTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNov 26, 1966 · N5274D · Substantial damage NTSB MKC67D0285Accident · No injuriesClosedPiper J-3 · Bonner Sprgs, KSNov 21, 1966 · N27020 · Substantial damage NTSB MKC67D0332Accident · No injuriesClosedPiper PA-28 · Olathe, KSNov 19, 1966 · N6439W · Substantial damage NTSB MKC67D0348Accident · No injuriesClosedBeech A23 · Hutchinson, KSNov 13, 1966 · N3574R · Substantial damage NTSB MKC67D0316Accident · No injuriesClosedPiper PA-24 · Topeka, KSNov 13, 1966 · N8031P · Substantial damage NTSB MKC67D0312Accident · No injuriesClosedBeech A23 · Garden City, KSNov 3, 1966 · N7912L · Substantial damage NTSB MKC67D0305Accident · No injuriesClosedCessna 150 · Cheney, KSNov 2, 1966 · N3160X · Substantial damage NTSB MKC67D0599Accident · No injuriesClosedCessna 310F · Salina, KSNov 1, 1966 · N6725X · Substantial damage NTSB MKC67D0324Accident · No injuriesClosedMooney M20E · Wallace, KSOct 30, 1966 · N2725W · Substantial damage NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage NTSB MKC67D0331Accident · No injuriesClosedMooney M20 · Ottawa, KSOct 25, 1966 · N5252B · Substantial damage NTSB MKC67D0253Accident · No injuriesClosedMooney M20C · Dexter, KSOct 24, 1966 · N5543Q · Substantial damage NTSB MKC67D0250Accident · No injuriesClosedBeech P35 · Wichita, KSOct 24, 1966 · N1544Z · Substantial damage NTSB MKC67F0323Accident · Serious injuriesClosedBeech A23-24 · Augusta, KSOct 23, 1966 · N2325W · Destroyed NTSB MKC67F0258Accident · Serious injuriesClosedPiper PA-24 · Kingman, KSOct 23, 1966 · N5723P · Substantial damage NTSB MKC67F0300Accident · No injuriesClosedBeech 23 · Burden, KSOct 22, 1966 · N2302Z · Substantial damage NTSB MKC67D0025Accident · No injuriesClosedCessna 210B · Liberal, KSOct 20, 1966 · N908SW · Substantial damage NTSB MKC67A0028Accident · 2 fatalClosedMooney M20E · Spring Hill, KSOct 13, 1966 · N7113U · Destroyed NTSB MKC68F0331Accident · No injuriesClosedBeech 95-55 · Great Bend, KSOct 6, 1966 · N9453Y · Substantial damage NTSB MKC67F0283Accident · No injuriesClosedBeech 23 · Lawrence, KSOct 5, 1966 · N3560R · Substantial damage NTSB MKC67F0245Accident · No injuriesClosedPiper PA-28 · Dodge City, KSOct 4, 1966 · N6294W · Substantial damage NTSB MKC67F0228Accident · Minor injuriesClosedChampion 7ECA · Stanley, KSSep 23, 1966 · N8394V · Substantial damage NTSB MKC67F0221Accident · Serious injuriesClosedCessna 195 · Hutchinson, KSSep 23, 1966 · N4328V · Destroyed NTSB MKC67F0248Accident · No injuriesClosedBeech B35 · Ottawa, KSSep 21, 1966 · N5045C · Substantial damage NTSB MKC67D0264Accident · No injuriesClosedPiper PA-28 · Wellington, KSSep 15, 1966 · N4692R · Substantial damage NTSB MKC67D0230Accident · Minor injuriesClosedCessna 172 · Caldwell, KSSep 14, 1966 · N4392L · Substantial damage NTSB MKC67F0217Accident · No injuriesClosedAeronca 65-LA · Rose Hill, KSSep 11, 1966 · N24240 · Substantial damage NTSB MKC67D0220Accident · Minor injuriesClosedCessna 150 · Brewster, KSSep 10, 1966 · N4628X · Substantial damage NTSB MKC67D0212Accident · No injuriesClosedCessna 175 · Ashland, KSSep 6, 1966 · N7135M · Substantial damage NTSB MKC67F0206Accident · No injuriesClosedBeech 35 · Toronto, KSSep 4, 1966 · N3149V · Substantial damage NTSB MKC67D0268Accident · No injuriesClosedPiper PA-22 · Larned, KSSep 3, 1966 · N3269Z · Substantial damage NTSB MKC67A0021Accident · 3 fatalClosedPiper PA-28 · Kansas City, KSSep 3, 1966 · N9074W · Destroyed NTSB MKC67F0180Accident · No injuriesClosedMooney M20 · Wichita, KSSep 2, 1966 · N866B · Substantial damage NTSB MKC68D0322Accident · No injuriesClosedBeech A-23A · Garden City, KSSep 1, 1966 · N2327W · Substantial damage NTSB MKC67D0150Accident · No injuriesClosedMooney M20C · Winona, KSAug 26, 1966 · N6841U · Substantial damage