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 UNK65X1130Accident · No injuriesClosedErcoupe 415C · Phillipsbur, KSDec 25, 1964 · N3804H · Substantial damage NTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KSDec 24, 1964 · N8463P · Substantial damage NTSB UNK65X1079Accident · No injuriesClosedCessna 337 · Wichita, KSDec 21, 1964 · N2119X · Substantial damage NTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSDec 20, 1964 · N89799 · Substantial damage NTSB UNK65X0993Accident · No injuriesClosedCessna 182 · Olathe, KSDec 12, 1964 · N2316G · 2 aircraft · Minor damage NTSB UNK65X0987Accident · No injuriesClosedMooney M20B · Emporia, KSDec 12, 1964 · N74587 · Substantial damage NTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSDec 12, 1964 · N8812B · Destroyed NTSB UNK65X0983Accident · No injuriesClosedBeechcraft S35 · Plainfield, KSDec 12, 1964 · N6864Q · Substantial damage NTSB UNK65X0930Accident · No injuriesClosedPiper PA22 · Marquette, KSDec 5, 1964 · N3652A · Substantial damage NTSB UNK65X0923Accident · No injuriesClosedPiper PA22 · Kansas City, KSDec 5, 1964 · N8298C · Substantial damage NTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSDec 5, 1964 · N2265D · Destroyed NTSB UNK65X0815Accident · Serious injuriesClosedAeronca 65TC · Salina, KSNov 24, 1964 · N34474 · Destroyed NTSB UNK65X0810Accident · No injuriesClosedBeechcraft B90 · Newton, KSNov 23, 1964 · N13309 · Substantial damage NTSB UNK65X0792Accident · No injuriesClosedStinson 108 · Emporia, KSNov 22, 1964 · N97350 · Substantial damage NTSB UNK65X0780Accident · No injuriesClosedPiper PA-12 · Atchison, KSNov 21, 1964 · N3889M · Substantial damage NTSB UNK65X0769Accident · No injuriesClosedPiper PA-24 · Olathe, KSNov 21, 1964 · N6822P · Substantial damage NTSB UNK65X0732Accident · Serious injuriesClosedLockheed L-749A · Wichita Kans, KSNov 15, 1964 · N6013C · Minor damage NTSB UNK65X0641Accident · No injuriesClosedBeechcraft K35 · Kansas City, KSNov 10, 1964 · N9507R · Substantial damage NTSB UNK65X0483Accident · No injuriesClosedBeechcraft 35 · Smith Center, KSOct 30, 1964 · N4540V · Substantial damage NTSB UNK65X0469Accident · No injuriesClosedLuscombe 8A · Olathe, KSOct 29, 1964 · N1985B · Substantial damage NTSB UNK65X0451Accident · No injuriesClosedBeechcraft C35 · Salina, KSOct 27, 1964 · N5905C · Substantial damage NTSB UNK65X0369Accident · No injuriesClosedMooney M20 · Wichita, KSOct 22, 1964 · N866B · Substantial damage NTSB UNK65X0316Accident · No injuriesClosedPiper PA22 · Topeka, KSOct 18, 1964 · N3171Z · Substantial damage NTSB UNK65X0304Accident · No injuriesClosedCessna 206 · Emporia, KSOct 17, 1964 · N5019U · Substantial damage NTSB UNK65X0291Accident · Minor injuriesClosedPiper PA28 · Topeka, KSOct 16, 1964 · N8703W · Destroyed NTSB UNK65X0246Accident · No injuriesClosedBeechraft 35 · Sabetha, KSOct 11, 1964 · N442B · Substantial damage NTSB UNK65X0243Accident · No injuriesClosedCessna 182 · Lawrence, KSOct 11, 1964 · N3560U · Substantial damage NTSB UNK65X0241Accident · No injuriesClosedCessna 172 · Windom, KSOct 11, 1964 · N7536T · Substantial damage NTSB UNK65X0220Accident · No injuriesClosedPiper PA24 · Atchison, KSOct 10, 1964 · N5024P · Substantial damage NTSB UNK65X0182Accident · No injuriesClosedBeechcraft 95 · Ness City, KSOct 7, 1964 · N2700Y · Substantial damage NTSB UNK64X4205Accident · No injuriesClosedMooney MK21 · Holsinton, KSSep 29, 1964 · N133W · Substantial damage NTSB UNK64X4190Accident · No injuriesClosedPiper PA-22 · Osage City, KSSep 28, 1964 · N1814A · Substantial damage NTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSSep 12, 1964 · N1806V · Substantial damage NTSB UNK64X3875Accident · No injuriesClosedPiper PA-22 · Liberal, KSSep 8, 1964 · N8908D · Substantial damage NTSB UNK64X3836Accident · Serious injuriesClosedScheibe SF26A · Phillipsburg, KSSep 6, 1964 · N1151Q · Substantial damage NTSB UNK64X3801Accident · No injuriesClosedBeechraft 23 · Osawatomie, KSSep 5, 1964 · N2359L · Substantial damage NTSB UNK64X3796Accident · No injuriesClosedMooney M20 · Kansas City, KSSep 5, 1964 · N6501U · Substantial damage NTSB UNK64X3635Accident · 2 fatalClosedCessna P206 · Wichita, KSAug 27, 1964 · N8464Z · Substantial damage NTSB UNK64X3628Accident · No injuriesClosedBeechcraft M23 · Liberal, KSAug 27, 1964 · N2303Q · Substantial damage NTSB UNK64X3580Accident · No injuriesClosedCessna 182 · Topeka, KSAug 25, 1964 · N6161B · Substantial damage NTSB UNK64X3574Accident · Minor injuriesClosedCessna 170 · Hays, KSAug 24, 1964 · N4612C · Destroyed NTSB UNK64X3564Accident · Minor injuriesClosedBeechcraft F35 · Haddam, KSAug 23, 1964 · N3868B · Substantial damage NTSB UNK64X3454Accident · No injuriesClosedBeechcraft M23 · Wichita, KSAug 18, 1964 · N2390J · Substantial damage NTSB UNK64X3398Accident · No injuriesClosedCessna 150 · Frankfort, KSAug 15, 1964 · N5539E · Substantial damage NTSB UNK64X3345Accident · No injuriesClosedPiper PA24 · Fall River, KSAug 12, 1964 · N7797P · Substantial damage NTSB UNK64X3316Accident · No injuriesClosedCessna 172 · Hill City, KSAug 10, 1964 · N8812B · Substantial damage NTSB UNK64X3311Accident · No injuriesClosedBell 47D1 · Rose Hill, KSAug 9, 1964 · N9713C · Substantial damage NTSB UNK64X3290Accident · No injuriesClosedBeechcraft 35 · Meade Lake, KSAug 9, 1964 · N3758N · Substantial damage NTSB UNK64X3266Accident · No injuriesClosedTaylorcraft DC065 · Salina, KSAug 8, 1964 · N47547 · Substantial damage NTSB UNK64X3127Accident · 1 fatalClosedAeronca 15AC · Cedar Vale, KSJul 30, 1964 · N1100H · Destroyed