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 MKC71DCQ32Accident · No injuriesClosedPiper PA-23 · Healy, KSFeb 28, 1971 · N3099P · Substantial damage NTSB MKC71DCQ30Accident · Minor injuriesClosedPiper J-3C · Russell, KSFeb 24, 1971 · N3517K · Substantial damage NTSB MKC71FCQ29Accident · No injuriesClosedHughes 269B · Wichita, KSFeb 16, 1971 · N9554F · Substantial damage NTSB MKC71FCQ31Accident · No injuriesClosedCessna 180 · Longton, KSFeb 14, 1971 · N9102C · Substantial damage NTSB MKC71FCQ28Accident · Serious injuriesClosedPiper PA-18A · Wichita, KSFeb 13, 1971 · N2880Z · Substantial damage NTSB MKC71FCG43Accident · Minor injuriesClosedAlon A-2 · Topeka, KSFeb 6, 1971 · N6578Q · Substantial damage NTSB MKC71FCQ27Accident · No injuriesClosedCessna 421 · Wichita, KSJan 28, 1971 · CFXWT · Substantial damage NTSB MKC71FCG40Accident · No injuriesClosedCessna 172K · Kansas City, KSJan 20, 1971 · N84768 · Substantial damage NTSB MKC71FCQ26Accident · Serious injuriesClosedPiper J5A · Varner, KSJan 19, 1971 · N40887 · Substantial damage NTSB MKC71DCG37Accident · No injuriesClosedPiper PA-16 · Topeka, KSDec 19, 1970 · N5920H · Substantial damage NTSB MKC71AK033Accident · 3 fatalClosedCessna 172 · Garden City, KSDec 15, 1970 · N6064A · Destroyed NTSB MKC71DCQ25Accident · No injuriesClosedLuscombe 8E · Hugoton, KSDec 14, 1970 · N1745K · Substantial damage NTSB DEN71ID027Incident · No injuriesClosedBoeing 747 · Hill City, KSDec 4, 1970 · N740PA · Minor damage NTSB MKC71DCQ24Accident · No injuriesClosedCessna 182M · Manhattan, KSDec 3, 1970 · N70697 · Substantial damage NTSB MKC71FCG34Accident · No injuriesClosedCessna 310 · Lawrence, KSNov 25, 1970 · N790S · Substantial damage NTSB MKC71AK027Accident · 2 fatalClosedRepublic F-105D · Wichita, KSNov 20, 1970 · AF610166 · 2 aircraft · Minor damage NTSB MKC71FCG33Accident · No injuriesClosedErco 415-E · Gardner, KSNov 15, 1970 · N94824 · Substantial damage NTSB MKC71FCG30Accident · Serious injuriesClosedBeech V35A · Kansas City, KSNov 5, 1970 · N8325N · Substantial damage NTSB MKC71FCQ22Accident · No injuriesClosedCessna 172K · El Dorado, KSOct 23, 1970 · N7080G · Substantial damage NTSB MKC71DCQ21Accident · No injuriesClosedCessna 180 · Sharon Sprgs, KSOct 22, 1970 · N1596C · Substantial damage NTSB MKC71AK017Accident · No injuriesClosedMooney M20E · Enterprise, KSOct 3, 1970 · N1287X · Substantial damage NTSB MKC71DCG27Accident · No injuriesClosedCessna 177 · Topeka, KSSep 30, 1970 · N2983X · Substantial damage NTSB MKC71FCQ20Accident · No injuriesClosedSmith DSA-1 · Goodland, KSSep 29, 1970 · N25P · Substantial damage NTSB MKC71FCQ19Accident · No injuriesClosedPiper PA-17 · Hutchinson, KSSep 13, 1970 · N4592H · Substantial damage NTSB MKC71AK012Accident · 2 fatalClosedCessna 150G · Stanley, KSSep 6, 1970 · N3627J · Destroyed NTSB MKC71DCQ18Accident · No injuriesClosedBrantly 305 · Emporia, KSSep 1, 1970 · N2221U · Substantial damage NTSB MKC71FCQ17Accident · Minor injuriesClosedCessna A188A · Edson, KSAug 31, 1970 · N5646J · Substantial damage NTSB MKC71FCG24Accident · Minor injuriesClosedBeech A23-19 · Leawood, KSAug 31, 1970 · N3671Q · Destroyed NTSB MKC71DCQ16Accident · Minor injuriesClosedPiper PA-28R · Concordia, KSAug 28, 1970 · N7608J · Substantial damage NTSB MKC71FCQ14Accident · No injuriesClosedPiper PA-22 · Dighton, KSAug 23, 1970 · N8623D · Substantial damage NTSB MKC71FCQ15Accident · No injuriesClosedCessna 401 · Baxter Sprgs, KSAug 21, 1970 · N8299F · Substantial damage NTSB MKC71DCG18Accident · No injuriesClosedBeech S35 · Topeka, KSAug 15, 1970 · N5720K · Substantial damage NTSB MKC71FCG20Accident · Serious injuriesClosedSlingsby T-49B · Desoto, KSAug 13, 1970 · N7475 · Destroyed NTSB MKC71FCQ11Accident · No injuriesClosedPiper PA-25 · Friend, KSAug 8, 1970 · N8639L · Substantial damage NTSB MKC71DCG15Accident · No injuriesClosedMooney M20E · Kansas City, KSAug 7, 1970 · N2716W · Substantial damage NTSB MKC71FCQ10Accident · Serious injuriesClosedSchultz BB · Harper, KSAug 6, 1970 · N2878 · Substantial damage NTSB MKC71AK005Accident · 2 fatalClosedPiper PA-30 · St John, KSAug 4, 1970 · N7525Y · Destroyed NTSB MKC71DCQ09Accident · No injuriesClosedBeech M-23 · Bazine, KSAug 3, 1970 · N2364J · Substantial damage NTSB MKC71DCQ08Accident · No injuriesClosedPiper PA-18 · Scott City, KSJul 31, 1970 · N4063Z · Substantial damage NTSB MKC71DCQ07Accident · No injuriesClosedNavion A · Meade, KSJul 29, 1970 · N4182K · Substantial damage NTSB MKC71DCQ06Accident · No injuriesClosedCessna 172E · Lincoln, KSJul 25, 1970 · N5560T · Substantial damage NTSB MKC71DCQ05Accident · No injuriesClosedBeech B-23 · Emporia, KSJul 25, 1970 · N7616R · Substantial damage NTSB MKC71DCQ04Accident · No injuriesClosedCessna 172 · Clay Center, KSJul 18, 1970 · N2990U · Substantial damage NTSB MKC71DCQ02Accident · No injuriesClosedBeech B23 · Wellington, KSJul 15, 1970 · N9110T · Substantial damage NTSB MKC71FCG04Accident · No injuriesClosedCessna 182 · Kansas City, KSJul 14, 1970 · N2007X · Substantial damage NTSB MKC71DCQ03Accident · No injuriesClosedCessna 150 · Dodge City, KSJul 14, 1970 · N60246 · Substantial damage NTSB MKC71FCQ13Accident · Minor injuriesClosedNavion A · Rolla, KSJul 13, 1970 · N8898H · Substantial damage NTSB MKC71AK002Accident · No injuriesClosedCessna 182L · Ottawa, KSJul 10, 1970 · N3418B · Substantial damage NTSB MKC71FCQ12Accident · No injuriesClosedBeech 95-B55 · Wichita, KSJul 7, 1970 · N8540M · Substantial damage NTSB MKC71FCQ01Accident · 1 fatalClosedPiper PA-25 · Harper, KSJul 1, 1970 · N4611Y · Destroyed