NTSB investigations, 2019, AL

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

Cases per year

20082026
NTSB investigations, 2019, AL per year, 2008–2026: 161 cases
200813
20098
20106
20118
201213
20137
201415
201514
20163
20178
201811
201910
20208
20216
20227
20239
20245
20254
20266

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\" = 'AL' 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 ERA20FA056Accident · 1 fatalClass 3 · FieldFinal reportBell 407 · Headland, ALPilot incapacitation by a sudden cardiac event related to severe coronary artery disease, which resulted in a loss of helicopter control.Dec 25, 2019 · N663SF · Substantial damageNTSB ERA20LA023Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Grand Bay, ALA loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.Oct 27, 2019 · N7009H · Substantial damageNTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.Sep 2, 2019 · N90104 · DestroyedNTSB ERA19LA264Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Foley, ALTotal loss of engine power due to a fatigue failure of the camshaft gear.Sep 1, 2019 · N878SR · Substantial damageNTSB ERA19LA260Accident · Serious injuriesClass 3 · LimitedFinal reportDG Flugzeugbau DG-500MB · Robertsdale, ALImpact with trees during the landing approach for reasons that could not be determined based on the available information.Aug 24, 2019 · N165MB · Substantial damageNTSB ERA19TA254Accident · Minor injuriesClass 3Final reportGIger Frank R Nieuport II · Talladega, ALA total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.Aug 17, 2019 · N112GV · Substantial damageNTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.Jun 21, 2019 · N4349C · Substantial damageNTSB ERA19TA185Accident · Minor injuriesClass 3Final reportCessna 182 · Robertsdale, ALThe pilot's failure to obtain the proper touchdown point while landing on a wet turf runway, which resulted in a runway overrun.Jun 4, 2019 · N7317Q · Substantial damageNTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.May 6, 2019 · N5542U · DestroyedNTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.Apr 20, 2019 · N1866B · Substantial damage