NTSB investigations, LA

10 cases where NTSB found Wire.

Cases per year

20082026
NTSB investigations, LA per year, 2008–2026: 10 cases
20082
20092
20121
20141
20172
20191
20231

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\" = 'LA' 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\", '03022032'))
  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 CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.Oct 28, 2023 · N910MG · Substantial damageNTSB GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.Jan 20, 2019 · N384TL · Substantial damageNTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.Nov 7, 2017 · N138WH · No damageNTSB CEN17FA169Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Collinston, LAThe failure of the flight instructor and the commercial pilot to maintain adequate clearance from a power line during an aerial application training flight.Apr 30, 2017 · N1899G · DestroyedNTSB CEN14LA425Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Braithwaite, LAThe pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.Aug 13, 2014 · N2272X · Substantial damageNTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.Aug 15, 2012 · N36289 · Substantial damageNTSB CEN09LA297Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Monroe, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.May 14, 2009 · N223SB · Substantial damageNTSB CEN09LA225Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Ville Platte, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.Mar 22, 2009 · N5189P · Substantial damageNTSB CEN09LA039Accident · Minor injuriesLimited investigationFinal reportChamberlin Victor Wayne Minimax · Winnsboro, LAThe pilot’s failure to maintain clearance from static wires while maneuvering to avoid another airplane.Oct 27, 2008 · N8637L · Substantial damageNTSB DFW08CA182Accident · No injuriesData collectionFinal reportAyres S2R · Baton Rouge, LAThe pilot's failure to maintain clearance from the transmission wire.Jul 11, 2008 · N2068B · Substantial damage