NTSB investigations, 2023, AL

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

Cases per year

20082026
NTSB investigations, 2023, 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\") = 2023
    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 ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.Dec 16, 2023 · N60932 · Substantial damageNTSB ERA24FA055Accident · 2 fatalClass 3 · FieldFinal reportBeech E95 · Elkmont, ALThe flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.Dec 4, 2023 · N369BB · Substantial damageNTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…Nov 27, 2023 · N4187Q · DestroyedNTSB ERA24LA047Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20F · Meridianville, ALThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.Nov 22, 2023 · N9339M · Substantial damageNTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…Sep 29, 2023 · N95SF · Substantial damageNTSB ERA23LA331Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Wetumpka, ALA total loss of engine power due to the separation of the No. 3 connecting rod from the crankshaft.Aug 11, 2023 · N7117M · Substantial damageNTSB ERA23LA325Accident · No injuriesClass 3 · LimitedFinal reportLong Charles Jackson Avid Flyer · Wetumpka, ALA loss of engine power due to fuel exhaustion because of a leaking fuel drain valve.Aug 3, 2023 · N3HH · Substantial damageNTSB ERA23LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA5A · Redstone Arsenal, ALThe separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.Jul 4, 2023 · N26387 · Substantial damageNTSB ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.Apr 6, 2023 · N272AM · Destroyed