OpenAirDocs.org

NTSB investigations, 2018, AL

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

Cases per year

20082026

Where

Open the map

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'
    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 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 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 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 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