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 MKC73FCG14Accident · No injuriesClosedPiper PA-28 · Leawood, KSOct 8, 1972 · N6698J · Substantial damage NTSB MKC73DCQ18Accident · No injuriesClosedMini-Ace CA-61 · Garden City, KSOct 7, 1972 · N612S · Substantial damage NTSB MKC73AKO25Accident · No injuriesClosedPiper PA-32 · Lawrence, KSOct 5, 1972 · N3655W · Substantial damage NTSB MKC73DCQ16Accident · No injuriesClosedCessna 150D · Great Bend, KSOct 3, 1972 · N4477U · Substantial damage NTSB MKC73AK024Accident · 1 fatalClosedAeronca 7AC · Ulysses, KSOct 1, 1972 · N1720E · Destroyed NTSB MKC73FCG12Accident · Minor injuriesClosedCessna 172E · Ft.Leavenwth, KSSep 27, 1972 · N6048 · Substantial damage NTSB MKC73DCQ15Accident · No injuriesClosedCessna 140 · Abilene, KSSep 17, 1972 · N89378 · Substantial damage NTSB MKC73FCQ13Accident · No injuriesClosedPiper PA-28 · Kalvesta, KSSep 13, 1972 · N7150W · Substantial damage NTSB MKC73DCQ14Accident · No injuriesClosedBellanca 14193A · Edna, KSSep 13, 1972 · N1250R · Substantial damage NTSB MKC73FCQ12Accident · Minor injuriesClosedCessna 150 · Goodland, KSSep 9, 1972 · N6292G · Destroyed NTSB MKC73DCQ11Accident · No injuriesClosedBeech C-45H · Wichita, KSAug 23, 1972 · N90682 · Substantial damage NTSB MKC73AK015Accident · Serious injuriesClosedPiper PA-23 · Fort Scott, KSAug 8, 1972 · N6550Y · Destroyed NTSB MKC73AK012Accident · 4 fatalClosedPiper PA-30 · Overbrook, KSAug 3, 1972 · N8245Y · Destroyed NTSB MKC73DCQ09Accident · No injuriesClosedBoeing E75 · Copeland, KSAug 1, 1972 · N65013 · Substantial damage NTSB MKC73AK011Accident · 2 fatalClosedN.American SNJ-5 · Kingman, KSJul 31, 1972 · N3194G · Destroyed NTSB MKC73DCQ07Accident · No injuriesClosedPiper J4A · Beaumont, KSJul 29, 1972 · N27078 · Substantial damage NTSB MKC73DCG03Accident · No injuriesClosedCessna 150G · Rantoul, KSJul 25, 1972 · N3868J · Destroyed NTSB MKC73DCQ08Accident · No injuriesClosedPiper PA-32 · Marysville, KSJul 24, 1972 · N4279R · Substantial damage NTSB MKC73FCQ05Accident · No injuriesClosedCessna A150K · Oakley, KSJul 16, 1972 · N5915J · Substantial damage NTSB MKC73AK009Accident · 1 fatalClosedCessna 150J · Caldwell, KSJul 15, 1972 · N61025 · Destroyed NTSB MKC73DCQ06Accident · No injuriesClosedPiper PA-28 · Utica, KSJul 14, 1972 · N5298S · Substantial damage NTSB MKC73FCQ03Accident · Serious injuriesClosedTaylorcraft BC12-D · Minneola, KSJul 9, 1972 · N95537 · Destroyed NTSB MKC73DCQ04Accident · No injuriesClosedCessna 180 · Newton, KSJul 9, 1972 · N2204C · Substantial damage NTSB MKC73FCO02Accident · No injuriesClosedBeech H35 · Newton, KSJul 7, 1972 · N5025B · Substantial damage NTSB MKC73DCQ01Accident · No injuriesClosedCessna 182M · Wichita, KSJul 6, 1972 · N91621 · Substantial damage NTSB MKC72DCQ63Accident · Minor injuriesClosedCessna 182 · Russell, KSJun 30, 1972 · N9364X · Substantial damage NTSB MKC73FCQ10Accident · No injuriesClosedCessna 150 · Augusta, KSJun 24, 1972 · N6458G · Substantial damage NTSB MKC73FCG07Accident · No injuriesClosedCessna 210 · Leawood, KSJun 23, 1972 · N7453E · Substantial damage NTSB MKC72DCG68Accident · Minor injuriesClosedCessna 172H · Lawrence, KSJun 17, 1972 · N3999Q · Substantial damage NTSB MKC72DCQ60Accident · Serious injuriesClosedCessna 150 · Phillipsburg, KSJun 16, 1972 · N4673X · Minor damage NTSB MKC72DCQ62Accident · No injuriesClosedBeech 23 · Riley, KSJun 15, 1972 · N6985Q · Substantial damage NTSB MKC72DCQ59Accident · No injuriesClosedCessna 172K · Hardtner, KSJun 11, 1972 · N7010G · Substantial damage NTSB MKC72DCG64Accident · No injuriesClosedPiper PA-28 · Basehor, KSJun 9, 1972 · N1877J · Substantial damage NTSB MKC72FCQ58Accident · 1 fatalClosedCallair A-9B · Ulysses, KSJun 4, 1972 · N7980V · Destroyed NTSB MKC72FCG57Accident · No injuriesClosedAeronca 7AC · Leawood, KSJun 4, 1972 · N1483E · Substantial damage NTSB MKC72DCG61Accident · No injuriesClosedBeech V35 · Valley Falls, KSJun 3, 1972 · N3772Q · Substantial damage NTSB MKC72AK064Accident · 2 fatalClosedBeech E18S · Winfield, KSJun 3, 1972 · N234AP · Destroyed NTSB MKC72DCG69Accident · No injuriesClosedCessna 140 · Topeka, KSMay 31, 1972 · N1878V · Substantial damage NTSB MKC72DCQ57Accident · No injuriesClosedPiper PA-25 · Laharpe, KSMay 26, 1972 · N6792Z · Substantial damage NTSB MKC72FCQ56Accident · Serious injuriesClosedPiper PA-18 · Laharpe, KSMay 20, 1972 · N7528K · Destroyed NTSB MKC72FCG55Accident · No injuriesClosedBeech C-45H · Paola, KSMay 20, 1972 · N8643E · Destroyed NTSB MKC72DCQ54Accident · No injuriesClosedPiper PA-25 · Trousdale, KSMay 16, 1972 · N7591Z · Substantial damage NTSB MKC72FCQ52Accident · Minor injuriesClosedCessna 150L · Augusta, KSMay 13, 1972 · N1662Q · Substantial damage NTSB MKC72DCQ53Accident · Minor injuriesClosedCessna 150 · Mcpherson, KSMay 13, 1972 · N3954U · Substantial damage NTSB MKC72DCQ55Accident · No injuriesClosedCessna 177 · Concordia, KSMay 8, 1972 · N29358 · Substantial damage NTSB MKC72FCG51Accident · Minor injuriesClosedCessna 172H · Gardner, KSMay 4, 1972 · N3864R · Destroyed NTSB MKC72AK059Accident · 1 fatalClosedLuscombe 8A · Council Grve, KSApr 27, 1972 · N1269B · Destroyed NTSB MKC72DCQ51Accident · No injuriesClosedPiper PA-32 · Elkhart, KSApr 21, 1972 · N4108R · Substantial damage NTSB MKC72DCQ50Accident · No injuriesClosedAero Comdr A9B · Mcpherson, KSApr 18, 1972 · N7998V · Substantial damage NTSB MKC72DCQ49Accident · No injuriesClosedCessna 172 · Norton, KSApr 13, 1972 · N5339R · Substantial damage