NTSB investigations, ID

4 cases where the first occurrence was “On ground/water encounter with weather”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations, ID per year, 1985–2026: 4 cases
1985	1
1992	1
1993	1
1995	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" = 'ID' 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" = 330) 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\" = 'ID' 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\" = 330)
  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" = 'ID' 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" = 330)
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 SEA95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idaho Falls, IDThe pilot's inadequate airspeed at liftoff. Contributing to the accident were high density altitude, tailwind conditions, the pilot's selection of an excessive takeoff flap setting, and a windshear encounter.Jul 24, 1995 · N4516K · Substantial damage NTSB SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.Sep 3, 1993 · N42708 · Substantial damage NTSB SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.Mar 2, 1992 · N425AV · Substantial damage NTSB SEA85LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Preston, IDThe acft landed at Preston, ID, for fuel in a x-wind of 15-20 KTS, gusting to 30 KTS. A gust at touchdown veered the acft to the rt. The plt attempted a go-around with full flaps. Flaps were reduced as a stall occurred. The acft hit the ground and bounced…Aug 19, 1985 · N54016 · Destroyed