NTSB investigations, ID

8 cases where NTSB found Monitoring other aircraft.

Cases per year

20082026
NTSB investigations, ID per year, 2008–2026: 8 cases
20081
20111
20132
20141
20161
20201
20241

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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02021540'))
  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 WPR24FA201Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Arco, IDA midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…Jun 20, 2024 · N802TP · 2 aircraft · DestroyedNTSB WPR20FA206Accident · 8 fatalClass 3 · FieldFinal reportCessna TU206 · Coeur d'Alene, IDThe failure of the pilots of both airplanes to see and avoid the other airplane.Jul 5, 2020 · N6373U · 2 aircraft · DestroyedNTSB WPR16LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Emmett, IDThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision.Jul 17, 2016 · N8184B · 2 aircraft · Substantial damageNTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.Jul 7, 2014 · N162CG · 2 aircraft · Substantial damageNTSB WPR13FA296Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Yellow Pine, IDThe pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately…Jun 28, 2013 · N1540P · 2 aircraft · Substantial damageNTSB WPR13CA139Accident · No injuriesData collectionFinal reportCessna 172F · Nampa, IDThe failure of the pilot of another airplane, who was taxiing with no intent for flight, to maintain proper visual lookout.Mar 2, 2013 · N8713U · Substantial damageNTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.Jun 21, 2011 · N1459B · Substantial damageNTSB SEA08FA116Accident · 3 fatalField investigationFinal reportCessna 172N · McCall, IDThe failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.May 3, 2008 · N75856 · 2 aircraft · Destroyed