NTSB investigations, 2003, ID

8 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 2003, ID per year, 1982–2026: 100 cases
19824
19835
19841
19866
19882
19891
19905
19915
19926
19932
19942
19953
19964
19977
19986
19996
20008
20013
20025
20038
20045
20054
20062

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 2003
    AND 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\" = 220)
  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.

NTSB SEA04LA030Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Elk City, IDThe pilot's failure to maintain clearance from trees during a go-around. Factors include dark night conditions and trees.Dec 26, 2003 · N1363U · Substantial damageNTSB SEA03LA199Accident · Serious injuriesLimited investigationFinal reportWood Avid Magnum · Kooskia, IDThe pilot's improper recovery from a bounced landing which led to a loss of control.Sep 30, 2003 · N1214W · Substantial damageNTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.Sep 13, 2003 · N5547B · DestroyedNTSB SEA03FA143Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · White Bird, IDThe failure of the pilot to maintain clearance with terrain while maneuvering. Factors contributing to the accident included the impairment of the pilot due to carbon monoxide exposure and the trees.Jul 17, 2003 · C-GBEN · DestroyedNTSB SEA03LA127Accident · Minor injuriesLimited investigationFinal reportLockheed 402-2 · Headquarters, IDThe pilot's improper preflight planning and improper fuel consumption calculations. Factors contributing to the accident included the unfavorable wind condition, the downdraft, and the trees.Jul 4, 2003 · N3380G · Substantial damageNTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.Jul 4, 2003 · N254M · DestroyedNTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.Jun 12, 2003 · N104CA · Substantial damageNTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.May 25, 2003 · N767 · Substantial damage