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 MKC72DCQ22Accident · No injuriesClosedPiper PA-28 · Seneca, KSAug 11, 1971 · N9878W · Substantial damage NTSB MKC72FCQ18Accident · No injuriesClosedStandard J-1 · Haven, KSAug 10, 1971 · N2826D · Substantial damage NTSB MKC72DCQ17Accident · No injuriesClosedPiper PA-30 · Mankato, KSAug 7, 1971 · N7065Y · Substantial damage NTSB MKC72AK010Accident · 2 fatalClosedBeech 95-C55 · Coats, KSAug 6, 1971 · N4893J · Destroyed NTSB MKC72DCQ16Accident · No injuriesClosedCessna 170A · Hoisington, KSAug 4, 1971 · N5738C · Substantial damage NTSB MKC72FCQ15Accident · Serious injuriesClosedPiper PA-18 · Johnson, KSJul 29, 1971 · N4328Z · Substantial damage NTSB MKC72DCQ13Accident · No injuriesClosedPiper PA-28 · Oakley, KSJul 24, 1971 · N5172L · Substantial damage NTSB MKC72DCQ12Accident · No injuriesClosedPiper PA-32 · Emporia, KSJul 24, 1971 · N4105W · Substantial damage NTSB MKC72FCQ10Accident · No injuriesClosedBoeing A75N1 · Abilene, KSJul 19, 1971 · N66617 · Substantial damage NTSB MKC72DCQ09Accident · No injuriesClosedBellanca 14-193 · Howard, KSJul 19, 1971 · N7607E · Substantial damage NTSB MKC72FCG05Accident · No injuriesClosedPiper PA-28 · Leawood, KSJul 16, 1971 · N5170W · Substantial damage NTSB MKC72DCQ08Accident · No injuriesClosedPiper PA-25 · Sharon Sprgs, KSJul 16, 1971 · N6191Z · Substantial damage NTSB MKC72AK005Accident · 2 fatalClosedBeech 35 · Mankato, KSJul 14, 1971 · N4538V · Destroyed NTSB MKC72DC014Accident · No injuriesClosedCessna 150 · Stafford, KSJul 12, 1971 · N3915U · Substantial damage NTSB MKC72DCQ06Accident · No injuriesClosedPiper PA-25 · Marion, KSJul 9, 1971 · N6583Z · Substantial damage NTSB MKC72FCQ05Accident · 1 fatalClosedSpinks 10 · Rose Hill, KSJul 6, 1971 · N12851 · Destroyed NTSB MKC72DCQ03Accident · Minor injuriesClosedCassutt Sport · Newton, KSJul 3, 1971 · N1115G · Substantial damage NTSB MKC72FCQ02Accident · Minor injuriesClosedPiper PA-28 · Great Bend, KSJul 2, 1971 · N7496R · Substantial damage NTSB MKC72FCQ11Accident · Serious injuriesClosedPiper PA-18 · Rolla, KSJun 30, 1971 · N3779P · Substantial damage NTSB MKC71FCQ46Accident · Minor injuriesClosedHughes 269-A · Wichita, KSJun 28, 1971 · N8719F · Destroyed NTSB MKC71DCG76Accident · No injuriesClosedBeech 23 · Olathe, KSJun 22, 1971 · N2342J · Substantial damage NTSB MKC72DCQ04Accident · No injuriesClosedPiper PA-28 · Oberlin, KSJun 20, 1971 · N7771W · Substantial damage NTSB MKC71DCQ45Accident · No injuriesClosedCessna 150 · Junctn City, KSJun 19, 1971 · N3920J · Substantial damage NTSB MKC71DCQ47Accident · No injuriesClosedCessna 182L · Hays, KSJun 18, 1971 · N42966 · Substantial damage NTSB MKC71FCG74Accident · No injuriesClosedPiper PA-28R · Garnett, KSJun 17, 1971 · N3095R · Substantial damage NTSB MKC71DCQ44Accident · No injuriesClosedCallair A-9 · Ulysses, KSJun 17, 1971 · N3572G · Substantial damage NTSB MKC71DCQ43Accident · No injuriesClosedCessna 180C · Syracuse, KSJun 16, 1971 · N9366T · Substantial damage NTSB MKC72DCQ07Accident · No injuriesClosedPiper PA-22 · Webber, KSJun 13, 1971 · N6025D · Substantial damage NTSB MKC71AK058Accident · 1 fatalClosedPiper PA-28R · Medicine Lge, KSJun 13, 1971 · N7416J · Destroyed NTSB MKC71IK057Incident · No injuriesClosedCessna 207 · Lawrence, KSMay 31, 1971 · N91099 · Minor damage NTSB MKC71DCQ42Accident · No injuriesClosedPiper PA-22 · Meade, KSMay 31, 1971 · N1779P · Substantial damage NTSB MKC71DCQ41Accident · Minor injuriesClosedCessna 182H · Beloit, KSMay 26, 1971 · N2029X · Substantial damage NTSB MKC71FCG66Accident · No injuriesClosedCessna 172D · Olathe, KSMay 17, 1971 · N2526U · Substantial damage NTSB MKC71DCQ40Accident · No injuriesClosedMooney M20F · Montezuma, KSMay 17, 1971 · N4024N · Substantial damage NTSB MKC71DCQ39Accident · No injuriesClosedPiper PA-25 · Yates Center, KSMay 8, 1971 · N6810Z · Substantial damage NTSB MKC71DCQ38Accident · Minor injuriesClosedPiper PA-25 · Morrowville, KSMay 8, 1971 · N4534Y · Substantial damage NTSB MKC71DCG65Accident · No injuriesClosedCessna 150H · Stillwell, KSMay 6, 1971 · N7132S · Substantial damage NTSB MKC71DCG62Accident · No injuriesClosedCallair A-6 · Tonganoxie, KSMay 3, 1971 · N2910G · Substantial damage NTSB MKC71IK054Incident · No injuriesClosedCessna 402 · Topeka, KSApr 26, 1971 · N4027Q · Minor damage NTSB MKC71DCG58Accident · No injuriesClosedBeech 95-B55 · Kansas City, KSApr 26, 1971 · N173D · Substantial damage NTSB MKC71DCQ35Accident · No injuriesClosedBoeing A75N1 · Liberal, KSApr 25, 1971 · N75321 · Substantial damage NTSB MKC71DCQ37Accident · No injuriesClosedCessna 182 · Garden City, KSApr 24, 1971 · N92243 · Substantial damage NTSB MKC71AKO51Accident · No injuriesClosedHughes 269A · Wichita, KSApr 22, 1971 · N8793F · Substantial damage NTSB MKC71DCQ36Accident · No injuriesClosedBeech J35 · Plainville, KSApr 21, 1971 · N8271D · Substantial damage NTSB MKC71DCG52Accident · Minor injuriesClosedCessna 182 · Olathe, KSApr 2, 1971 · N2760F · Substantial damage NTSB MKC71FCG51Accident · No injuriesClosedCessna 182L · Kansas City, KSMar 29, 1971 · N3418R · Substantial damage NTSB MKC71DCQ34Accident · No injuriesClosedCessna 177 · Hill City, KSMar 20, 1971 · N3116T · Substantial damage NTSB MKC71AK049Accident · No injuriesClosedLockheed Ga 382B · Wichita, KSMar 18, 1971 · N14ST · Substantial damage NTSB MKC71DCG47Accident · No injuriesClosedPiper PA-24 · Olathe, KSMar 14, 1971 · N6424P · Substantial damage NTSB MKC71DCQ33Accident · No injuriesClosedCessna 150J · Protection, KSMar 2, 1971 · N61000 · Substantial damage