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 MKC79FCG33Accident · No injuriesClosedCessna 210K · Olathe, KSFeb 25, 1979 · N9471M · Substantial damage NTSB MKC79FCG29Accident · No injuriesClosedCessna 177RG · Kansas City, KSFeb 16, 1979 · N2074Q · Substantial damage NTSB MKC79DCQ13Accident · No injuriesClosedCessna R-182 · Greenburg, KSFeb 9, 1979 · N3167C · Substantial damage NTSB MKC79FCQ14Accident · Serious injuriesClosedCessna 414 · Arlington, KSFeb 7, 1979 · N141WB · 2 aircraft · Destroyed NTSB MKC79FCG24Accident · No injuriesClosedPiper PA-28 · Ottawa, KSJan 28, 1979 · N9356C · Substantial damage NTSB MKC79FCQ11Accident · Minor injuriesClosedPiper PA-31 · Dodge City, KSJan 23, 1979 · N23L · Substantial damage NTSB MKC79DCQ12Accident · No injuriesClosedCessna 150 · Kinsley, KSJan 21, 1979 · N7271S · Substantial damage NTSB MKC79DCQ09Accident · No injuriesClosedCessna 152 · Emporia, KSJan 19, 1979 · N757CX · Substantial damage NTSB MKC79DCQ10Accident · No injuriesClosedPiper PA-28 · Abilene, KSJan 17, 1979 · N1449T · Substantial damage NTSB MKC79FA014Accident · 1 fatalClosedCessna 210L · Junction City, KSJan 12, 1979 · N4685Q · Destroyed NTSB MKC79DCQ08Accident · No injuriesClosedCessna 172 · Beaumont, KSJan 4, 1979 · N13093 · Substantial damage NTSB MKC79DCQ07Accident · No injuriesClosedCessna 172 · Sedgwick, KSDec 27, 1978 · N6161E · Substantial damage NTSB MKC79FCQ06Accident · No injuriesClosedMooney M20F · Cedar Point, KSDec 23, 1978 · N7767M · Substantial damage NTSB MKC79DCQ05Accident · Serious injuriesClosedCessna 182 · Dighton, KSDec 14, 1978 · N8997X · Destroyed NTSB MKC79DA013Accident · Serious injuriesClosedBarnes AX-7 · Hutchinson, KSDec 3, 1978 · N2033F · Substantial damage NTSB MKC79DCQ04Accident · No injuriesClosedBeech V35 · Liberal, KSNov 27, 1978 · N2002W · Substantial damage NTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNov 16, 1978 · N901PC · Destroyed NTSB MKC79FCQ03Accident · Serious injuriesClosedPiper PA-28 · Lyons, KSNov 5, 1978 · N4651R · Substantial damage NTSB MKC79FA001Accident · 4 fatalClosedBeech A23-24 · Lyndon, KSNov 5, 1978 · N6135N · Destroyed NTSB MKC79DCQ02Accident · Minor injuriesClosedPiper PA-28 · Palco, KSNov 3, 1978 · N8411C · Substantial damage NTSB MKC79DA005Accident · No injuriesClosedBarnes AX-7 · Overland Park, KSNov 1, 1978 · N2482H · Substantial damage NTSB MKC79FCQ01Accident · No injuriesClosedCessna 152 · Oakley, KSOct 4, 1978 · N69221 · Substantial damage NTSB MKC78DA070Accident · No injuriesClosedCessna 401A · Garden City, KSSep 18, 1978 · N6238Q · Substantial damage NTSB MKC78FCQ39Accident · Serious injuriesClosedLuscombe 8A · Baxter Springs, KSSep 10, 1978 · N45455 · Substantial damage NTSB MKC78DCG66Accident · No injuriesClosedCessna 152 · Waverly, KSSep 9, 1978 · N25478 · Substantial damage NTSB MKC78FCG65Accident · No injuriesClosedPiper PA-28 · Olathe, KSSep 7, 1978 · N43193 · Substantial damage NTSB MKC78DCG64Accident · No injuriesClosedCessna 152 · Olathe, KSSep 6, 1978 · N49970 · Substantial damage NTSB MKC78FCQ38Accident · No injuriesClosedCessna 177RG · Wellington, KSSep 3, 1978 · N45318 · Substantial damage NTSB MKC78FCG63Accident · No injuriesClosedRyan PT-22 · Hiawatha, KSSep 2, 1978 · N48587 · Substantial damage NTSB MKC78DCQ37Accident · No injuriesClosedCessna 182P · Garden City, KSAug 31, 1978 · N5701J · Substantial damage NTSB MKC78DCQ34Accident · No injuriesClosedCessna 188 · Oxford, KSAug 30, 1978 · N9323G · Substantial damage NTSB MKC78FA063Accident · 3 fatalClosedCessna 177 · Plainville, KSAug 12, 1978 · N2319Y · Destroyed NTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSAug 7, 1978 · N36EZ · Destroyed NTSB MKC78FCG57Accident · No injuriesClosedCessna 320 · Olathe, KSAug 6, 1978 · N5731X · Substantial damage NTSB MKC78DCG55Accident · No injuriesClosedPitts S-1 · Olathe, KSAug 5, 1978 · N11SW · Substantial damage NTSB MKC78FCG56Accident · No injuriesClosedCessna 175 · Leawood, KSAug 3, 1978 · N9382B · Substantial damage NTSB MKC78FA059Accident · Serious injuriesClosedCessna 402A · Manhattan, KSAug 3, 1978 · N4545Q · Substantial damage NTSB MKC78DCQ35Accident · No injuriesClosedCessna 188 · Sharon Spring, KSAug 3, 1978 · N9952G · Substantial damage NTSB MKC78FCQ33Accident · No injuriesClosedPiper PA-25 · Edson, KSJul 25, 1978 · N6919Z · Substantial damage NTSB MKC78DCQ32Accident · No injuriesClosedPitts S1C · Moscow, KSJul 24, 1978 · N77LB · Substantial damage NTSB MKC78FCG51Accident · No injuriesClosedPitts S2A · Ottawa, KSJul 20, 1978 · N99FS · Substantial damage NTSB MKC78FA056Accident · 2 fatalClosedCessna 150 · Columbus, KSJul 19, 1978 · N18544 · Destroyed NTSB MKC78FCG48Accident · No injuriesClosedCessna 182E · Olathe, KSJul 17, 1978 · N3075Y · Destroyed NTSB MKC78DCG52Accident · No injuriesClosedHughes 269A · Springhill, KSJul 17, 1978 · N8864F · Substantial damage NTSB MKC78DCG49Accident · Minor injuriesClosedPiper PA-22 · Severance, KSJul 14, 1978 · N5548Z · Destroyed NTSB MKC78FCG41Accident · Minor injuriesClosedPiper PA-28 · Olathe, KSJul 1, 1978 · N666KC · Substantial damage NTSB MKC78DCQ30Accident · No injuriesClosedUniv Acft D-16 · Valley Center, KSJul 1, 1978 · N91773 · Substantial damage NTSB MKC78FCG42Accident · Serious injuriesClosedBoeing E75-N1 · Olathe, KSJun 30, 1978 · N4812N · Destroyed NTSB MKC78FCG39Accident · Serious injuriesClosedBeech A36 · Olathe, KSJun 25, 1978 · N72MB · Substantial damage NTSB MKC78DCQ28Accident · Minor injuriesClosedPiper PA-28R · Smith Center, KSJun 25, 1978 · N3850T · Substantial damage