NTSB investigations, 2019, NE

8 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2019, NE per year, 2008–2026: 95 cases
20086
20094
20104
20114
20128
20136
20142
20153
20166
20177
201810
20198
20204
20213
20225
20233
20247
20253
20262

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\") = 2019
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN20LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 525A · Scotts Bluff, NEThe installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.Dec 18, 2019 · CGOJG · Substantial damageNTSB GAA19CA570Accident · Serious injuriesData collectionFinal reportCirrus SR22 · Lexington, NEThe pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.Sep 25, 2019 · N1216N · Substantial damageNTSB GAA19CA480Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Waco, NEThe pilot's failure to maintain clearance from wires during an agricultural application flight.Aug 4, 2019 · N730JD · Substantial damageNTSB CEN19LA240Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Blair, NEThe failure of the lower actuator bearing support bracket, which resulted in the misalignment of the clutch actuator, the loss of belt tension on the main rotor drive system, and the subsequent forced landing on sloped terrain.Jul 27, 2019 · N7508Z · Substantial damageNTSB GAA19CA454Accident · No injuriesData collectionFinal reportCessna T188 · Deshler, NEThe pilot's failure to maintain clearance from wires during low-altitude maneuvering.Jul 24, 2019 · N3367J · Substantial damageNTSB CEN19LA186Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Omaha, NEThe loss of engine power due to fuel starvation.Jun 28, 2019 · N5256Q · Substantial damageNTSB CEN19LA121Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Omaha, NEA partial loss of engine power for reasons that could not be determined based on the available evidence.Apr 16, 2019 · N109PD · Substantial damageNTSB GAA19CA160Accident · No injuriesData collectionFinal reportPiper PA18 · Rushville, NEThe partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.Mar 8, 2019 · N8566D · Substantial damage