NTSB investigations, 2018, AL

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
NTSB investigations, 2018, AL per year, 1962–2026: 2,501 cases
19621
19631
196461
196592
196670
196785
196868
196975
197089
197173
197276
197382
197467
197571
197677
197782
197872
197950
198050
198148
198261
198360
198441
198545
198648
198745
198836
198933
199032
199130
199240
199333
199427
199542
199632
199717
199827
199929
200017
200125
200227
200330
200427
200522
200624
200729
200828
200913
20108
201117
201225
201310
201424
201523
201612
201719
201820
201915
202017
202115
202221
202319
202411
202518
202617

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\") = 2018
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
  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 ERA19FA047Accident · 2 fatalClass 2 · FieldFinal reportBell OH 58C · Verbena, ALThe pilot's improper decision to conduct a low-level flight over a river, and his failure to see and avoid power lines, which resulted in the helicopter's impact with power lines and the water.Nov 16, 2018 · N510CP · Substantial damageNTSB ERA19LA031Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Elba, ALA leak in the pitot-static system for reasons that could not be determined based on the available information, which resulted in an airspeed indication error, an aborted takeoff, and a subsequent runway overrun.Oct 28, 2018 · N20BK · Substantial damageNTSB ERA19LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Opelika, ALThe improper torque application and ongoing inspection of an oil filter adaptor by maintenance personnel, which resulted in a loss of lubrication and a catastrophic engine failure.Oct 16, 2018 · N9398G · Substantial damageNTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.Aug 22, 2018 · N88287 · Substantial damageNTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.Aug 4, 2018 · N424A · DestroyedNTSB ERA18LA195Accident · No injuriesLimited investigationFinal reportEagle DW1 · Ider, ALFatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.Jul 18, 2018 · N8805X · Substantial damageNTSB ERA18LA188Accident · 1 fatalLimited investigationFinal reportNorthwing 17 · Section, ALThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during an aborted landing. Contributing to the accident was the pilot's lack of flight experience in the aircraft.Jul 9, 2018 · N959RR · Substantial damageNTSB ERA18LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Gulf Shores, ALThe pilot's improper preflight and in-flight fuel planning, which resulted in fuel exhaustion to the left engine and a total loss of engine power during an attempted go-around maneuver.Jul 7, 2018 · N294AB · Substantial damageNTSB ERA18LA182Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 25 · Flat Rock, ALThe failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion.Jun 30, 2018 · N6307Z · Substantial damageNTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 24, 2018 · N19MM · DestroyedNTSB GAA18CA332Accident · No injuriesData collectionFinal reportWaco YKS 7 · Fairhope, ALThe pilot’s failure to maintain directional control while landing.Jun 8, 2018 · N17473 · Substantial damageNTSB ERA18LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Fort Morgan, ALA partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 7, 2018 · N755KT · Substantial damageNTSB WPR18LA144Accident · No injuriesLimited investigationFinal reportRyan Navion · Jasper, ALThe other pilot's failure to maintain clearance from another airplane in the formation flight due to sun glare.May 21, 2018 · N4356K · 2 aircraft · Substantial damageNTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…May 13, 2018 · N486T · DestroyedNTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.May 11, 2018 · N9216E · Substantial damageNTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.May 5, 2018 · N81FS · Substantial damageNTSB CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.Apr 25, 2018 · N89904 · Substantial damageNTSB ERA18FA118Accident · 1 fatalField investigationFinal reportCessna R182 · Ashville, ALDescent and impact with terrain for reasons that could not be determined.Mar 28, 2018 · N3167C · DestroyedNTSB GAA18CA178Accident · No injuriesData collectionFinal reportFlightworks Capella XS FW2C80TD · Hartselle, ALThe pilot's failure to maintain directional control during the landing roll.Mar 23, 2018 · N654MM · Substantial damageNTSB ERA18LA073Accident · No injuriesLimited investigationFinal reportAero Commander 680 F · Lapine, ALThe pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…Jan 27, 2018 · N900L · Substantial damage