NTSB investigations, 2017

16 cases where NTSB found Aircraft.

Cases per year

20082026
NTSB investigations, 2017 per year, 2008–2026: 116 cases
20088
20094
20103
20113
20124
20132
201410
20157
20167
201716
201810
20199
20206
20218
20222
20234
202411
20251
20261

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\") = 2017
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022040'))
  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 GAA18CA087Accident · No injuriesData collectionFinal reportMaule MX7 · Willow, AKThe pilot’s failure to see and avoid another airplane stopped on the taxiway while taxiing in sun glare conditions.Dec 18, 2017 · N61SR · 2 aircraft · Substantial damageNTSB ERA18LA055Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright.Dec 16, 2017 · N199RN · 2 aircraft · Substantial damageNTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.Oct 20, 2017 · N25YD · 2 aircraft · Substantial damageNTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.Oct 6, 2017 · N123UT · 2 aircraft · Substantial damageNTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.Sep 21, 2017 · UNREG · 2 aircraft · DestroyedNTSB WPR17LA209Accident · No injuriesLimited investigationFinal reportTrudel GP 4 · Reno, NVThe other pilot's failure to maintain clearance from the airplane during the line-abreast formation.Sep 17, 2017 · C-GTPX · 2 aircraft · Minor damageNTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.Sep 13, 2017 · N121CZ · Substantial damageNTSB GAA17CA458Accident · No injuriesData collectionFinal reportRandall Marvin L Vans RV 3A · Spokane, WAThe other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.Jul 28, 2017 · N16MR · 2 aircraft · Substantial damageNTSB GAA17CA411Accident · No injuriesData collectionFinal reportSpani Wayne M Starduster TOO SA300 · San Diego, CAThe other pilot's failure to maintain separation from a stationary airplane during the taxi to the runway.Jul 16, 2017 · N506WS · 2 aircraft · Minor damageNTSB GAA17CA395Accident · No injuriesData collectionFinal reportCessna R182 · San Jose, CAThe other pilot’s failure to maintain separation from another airplane in the run-up area while taxiing.Jul 8, 2017 · N1746R · 2 aircraft · Minor damageNTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.May 17, 2017 · N4804F · Substantial damageNTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.Apr 8, 2017 · N88470 · 2 aircraft · Substantial damageNTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.Mar 24, 2017 · N13499 · Substantial damageNTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.Mar 14, 2017 · N3654M · Substantial damageNTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.Mar 11, 2017 · N865MA · Substantial damageNTSB GAA17CA119Accident · No injuriesData collectionFinal reportCessna 175 · Lakeport, CAThe pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.Jan 6, 2017 · N8148T · Substantial damage