Skip to content

NTSB investigations, ID

16 cases where the first occurrence was “On ground/water encounter with terrain/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

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" = 320) 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\" = 320)
  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" = 320)
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 SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.Feb 13, 2004 · N2216M · Substantial damage NTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.Sep 26, 2003 · N9707G · Substantial damage NTSB SEA02LA188Accident · No injuriesLimited investigationFinal reportAviat A-1B · Arco, IDThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent ground loop. Factors include wind gusts during the period of time at which the landing took place.Sep 8, 2002 · N290AM · Substantial damage NTSB SEA02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include high density altitude, variable winds, and a ditch near the point where the aircraft departed the side of the runway.Aug 28, 2002 · N5781F · Substantial damage NTSB SEA02LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Cascade, IDThe pilot's inadequate decision and his improper setting of the propeller controls. Contributing factors were a tailwind, high density altitude, and swampy terrain.Aug 4, 2002 · N58818 · Substantial damage NTSB SEA02LA081Accident · Minor injuriesLimited investigationFinal reportCook Coot A · Harrison, IDThe pilot's failure to detect an unsafe boat wake during the landing process, and his inadvertent initiation of a porpoise after coming in contact with the boat wake just after touchdown on a body of water. Factors include a large wake wave/swell created by…May 12, 2002 · N12QQ · Substantial damage NTSB SEA02LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Sulfur Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include the pilot's excessive rotation attitude, and soft/wet terrain conditions.Oct 13, 2001 · N20877 · Substantial damage NTSB SEA00LA111Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Mountain Home, IDThe pilot's decision to takeoff in unfavorable weather conditions without first calculating takeoff performance data. Factors include gusty winds, downdrafts, terrain-induced turbulence, and rough/uneven terrain where the pilot elected to make the…Jun 21, 2000 · N8865K · Substantial damage NTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.Aug 23, 1999 · N2808F · Substantial damage NTSB SEA97LA205Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate planning/decision for taking off in the meteorological conditions present at the time. Factors include a high density altitude, gusty winds, downdrafts, and soft terrain in the area of the forced landing.Sep 7, 1997 · N7494Q · Substantial damage NTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…Nov 7, 1996 · N32518 · Substantial damage NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.Mar 3, 1996 · N2925V · Substantial damage NTSB SEA91LA191Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hamer, IDThe pilot's failure to maintain runway aligment. Factors include high vegetation, and an inadverent ground loop/swerve.Jul 24, 1991 · N6702Q · Substantial damage NTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.Sep 23, 1988 · N3647N · Substantial damage NTSB SEA82DA160Accident · No injuriesFinal reportCessna 152 · Bonners Ferry, IDAfter refueling, the pilot attempted to takeoff from a field. The first takeoff attempt was aborted. During the second takeoff roll the aircraft nose gear struck a ditch, causing the aircraft to nose over.Sep 11, 1982 · N67323 · Substantial damage NTSB SEA82DA036Accident · No injuriesFinal reportPiper PA-32-301T · Hailey, IDAfter an engine run-up with the parking brake set, the first attempt to takeoff was aborted when the plane failed to accelerate satisfactorily. The brakes operated satisfactorily during the abort and a second run-up revealed no unusual engine indications.…Mar 13, 1982 · N83764 · Substantial damage