NTSB investigations, KS

3 cases where the first occurrence was “Nose gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, KS per year, 1982–2026: 3 cases
1982	1
1983	1
1988	1

Where

Open the map

Latest cases

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192) 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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 192)
  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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192)
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 MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…May 24, 1988 · N7011L · Substantial damage NTSB MKC83IA063Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Salina, KSThe acft was on a flt from pitsburg, pa to Salina, KS with an en route stop at st louis, MO. During a briefing at pitsburg, the plt was advised of a NOTAM that the north 6800 ft of rwy 17/35 was closed, rwy lights obscured, 10 ft snowbanks. He did not get a…Feb 5, 1983 · N709US · Minor damage NTSB MKC82DA164Accident · No injuriesFinal reportBeech 95-B55 · Goodland, KSThe pilot was on a cross-country flight with a refueling stop at Goodland, KS. During arrival at Goodland, he elected to land on runway 05. There was no evidence that he established radio contact with Goodland flight service, located on the airport, for an…Sep 2, 1982 · N8453N · Substantial damage