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 MKC77DCQ20Accident · No injuriesClosedCessna 170B · Hugoton, KSMar 2, 1977 · N2201D · Substantial damage NTSB MKC77DCQ19Accident · No injuriesClosedGrumman AA-1B · Newton, KSFeb 19, 1977 · N9938L · Substantial damage NTSB MKC77DCQ18Accident · Minor injuriesClosedHughes 269A · Caldwell, KSFeb 18, 1977 · N8751F · Substantial damage NTSB MKC77FCG14Accident · No injuriesClosedPiper PA-28 · Hiawatha, KSFeb 13, 1977 · N6481R · Substantial damage NTSB MKC77DCQ17Accident · Minor injuriesClosedPiper PA-28 · Herington, KSFeb 13, 1977 · N9545W · Destroyed NTSB MKC77FA013Accident · 6 fatalClosedPiper PA-31 · Anthony, KSFeb 11, 1977 · N59838 · Destroyed NTSB MKC77FCQ16Accident · Minor injuriesClosedCessna 172 · Benton, KSFeb 6, 1977 · N6797H · Substantial damage NTSB MKC77DA012Accident · Serious injuriesClosedSwearingen SA-226 · Parsons, KSFeb 2, 1977 · N224AM · No damage NTSB MKC77DCG12Accident · No injuriesClosedCessna 150 · Lyndon, KSJan 30, 1977 · N51206 · Substantial damage NTSB MKC77DCQ15Accident · No injuriesClosedLuscombe 8E · Wichita, KSJan 29, 1977 · N2401K · Substantial damage NTSB MKC77FCG11Accident · No injuriesClosedCessna 177RG · Garnett, KSJan 25, 1977 · N1917Q · Substantial damage NTSB MKC77DCQ14Accident · No injuriesClosedAeronca 11AC · Tetmore, KSJan 21, 1977 · N9539E · Substantial damage NTSB MKC77DCQ13Accident · No injuriesClosedMaule M-4 · Coldwater, KSJan 3, 1977 · N40303 · Substantial damage NTSB MKC77DCQ12Accident · No injuriesClosedCessna 172 · Alma, KSDec 25, 1976 · N3563S · Substantial damage NTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damage NTSB MKC77DCQ10Accident · No injuriesClosedCessna U206 · Wichita, KSDec 9, 1976 · N7297N · Substantial damage NTSB MKC77DCQ09Accident · No injuriesClosedJohnson Scamp · Pratt, KSDec 4, 1976 · N25172 · Substantial damage NTSB MKC77FCQ08Accident · 1 fatalClosedBede BD-5G · Newton, KSNov 23, 1976 · N503BD · Destroyed NTSB MKC77FA005Accident · 2 fatalClosedChampion 7GCBC · Lincoln, KSNov 20, 1976 · N1852G · Destroyed NTSB MKC77FA002Accident · 1 fatalClosedAero Comdr 690A · Independence, KSNov 17, 1976 · N57186 · Destroyed NTSB MKC77DCQ06Accident · Minor injuriesClosedCessna 172 · Fort Scott, KSNov 16, 1976 · N6640A · Substantial damage NTSB MKC77DCG06Accident · No injuriesClosedCessna 177 · Lawrence, KSNov 6, 1976 · N2235Y · Substantial damage NTSB MKC77FCQ04Accident · Minor injuriesClosedPiper PA-23 · Wichita, KSNov 3, 1976 · N4158P · Substantial damage NTSB MKC77DCG05Accident · Minor injuriesClosedPiper PA-22 · Oskaloosa, KSNov 1, 1976 · N7700D · Substantial damage NTSB MKC77FCQ03Accident · Serious injuriesClosedCessna 182P · Kinsley, KSOct 19, 1976 · N4657K · Substantial damage NTSB MKC77FCG02Accident · Minor injuriesClosedMarschel T-18 · Leawood, KSOct 10, 1976 · N4822 · Substantial damage NTSB MKC76FCQQ1Accident · No injuriesClosedErco 415-C · St Marys, KSOct 9, 1976 · N99061 · Substantial damage NTSB MKC77FCQ02Accident · No injuriesClosedCessna 310G · Garden City, KSOct 2, 1976 · N8902Z · Substantial damage NTSB MKC76DCH01Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 29, 1976 · N8013S · Substantial damage NTSB MKC76FCQ78Accident · Minor injuriesClosedDavison KR-2 · Dodge City, KSSep 23, 1976 · N15LD · Substantial damage NTSB MKC76DCQ77Accident · No injuriesClosedCessna 205 · Winona, KSSep 19, 1976 · N8495Z · Substantial damage NTSB MKC76AK082Accident · 2 fatalClosedAir & Space 18A. · Oxford, KSSep 18, 1976 · N73546 · Destroyed NTSB MKC76FCQ76Accident · No injuriesClosedCessna 305 · Manhattan, KSAug 25, 1976 · N6258 · Substantial damage NTSB MKC76DCQ75Accident · Minor injuriesClosedBeech J35 · El Dorado, KSAug 23, 1976 · N7216B · Substantial damage NTSB MKC76AK078Accident · No injuriesClosedCessna 402 · Hays, KSAug 17, 1976 · N4055Q · Substantial damage NTSB MKC76FCG95Accident · No injuriesClosedTed Smith 600 · Topeka, KSAug 13, 1976 · N7512S · Substantial damage NTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damage NTSB MKC760CQ73Accident · No injuriesClosedHughes 269A · Alden, KSAug 7, 1976 · N8873F · Substantial damage NTSB MKC76DCQ74Accident · No injuriesClosedCessna 150 · Clay Center, KSAug 6, 1976 · N7053S · Substantial damage NTSB MKC76DCQ70Accident · No injuriesClosedAero-Comdr 600S2R · Leoti, KSAug 4, 1976 · N5016X · Substantial damage NTSB MKC76FCQ71Accident · Serious injuriesClosedPiper PA-28 · Coffeyville, KSAug 3, 1976 · N4819L · Substantial damage NTSB MKC76FCQ69Accident · Minor injuriesClosedCessna T210J · Wichita, KSAug 3, 1976 · N2263R · Substantial damage NTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damage NTSB MKC76AK070Accident · 2 fatalClosedPiper PA-34 · Greensburg, KSJul 27, 1976 · N56712 · Substantial damage NTSB MKC76FCG87Accident · Minor injuriesClosedAero Comdr 500B · Topeka, KSJul 19, 1976 · N299PE · Substantial damage NTSB MKC76DCQ67Accident · No injuriesClosedErco 415-C · Derby, KSJul 18, 1976 · N94102 · Substantial damage NTSB MKC76AK067Accident · 1 fatalClosedGlasflugel H-201B · Alden, KSJul 17, 1976 · N1WN · Substantial damage NTSB MKC76DCQ66Accident · No injuriesClosedBeech G33 · Eureka, KSJul 11, 1976 · N166B · Substantial damage NTSB MKC76DCQ65Accident · No injuriesClosedCessna 150E · Moline, KSJul 10, 1976 · N3534J · Substantial damage NTSB MKC76DCG84Accident · No injuriesClosedPiper PA-23 · Lyndon, KSJul 6, 1976 · N1441P · Substantial damage