NTSB investigations, 2018

431 cases where NTSB found Physical environment.

Cases per year

20082026
NTSB investigations, 2018 per year, 2008–2026: 5,697 cases
2008604
2009361
2010303
2011244
2012265
2013274
2014379
2015332
2016421
2017457
2018431
2019396
2020251
2021221
2022198
2023186
2024172
2025129
202673

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0302'))
  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 ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.Dec 31, 2018 · N78JE · Substantial damageNTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.Dec 30, 2018 · N2651R · Substantial damageNTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.Dec 29, 2018 · N6202M · Substantial damageNTSB CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 29, 2018 · N1095V · DestroyedNTSB WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.Dec 28, 2018 · N8319T · Substantial damageNTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.Dec 27, 2018 · N17SJ · Substantial damageNTSB CEN19TA075Accident · Minor injuriesFinal reportMBB BK117 · Strum, WIThe pilot's failure to maintain clearance from the fire truck.Dec 25, 2018 · N145EC · Substantial damageNTSB ANC19CA009Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot's improper decision to land on a roadway during dark night conditions with inoperable landing and taxi lights, which resulted in an impact with a snow berm.Dec 23, 2018 · N93018 · Substantial damageNTSB ERA19LA091Accident · Serious injuriesLimited investigationFinal reportCzech Sport Sportcruiser · Naples, FLCollision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.Dec 22, 2018 · N564SC · Substantial damageNTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.Dec 21, 2018 · N254RA · Substantial damageNTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.Dec 20, 2018 · N8487X · Substantial damageNTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.Dec 19, 2018 · N636M · Substantial damageNTSB GAA19CA103Accident · No injuriesData collectionFinal reportRobinson R44 · Strykersville, NYThe structural failure of the home-built landing platform during landing, which resulted in the helicopter rolling over.Dec 18, 2018 · N7535S · Substantial damageNTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.Dec 17, 2018 · N4886B · Substantial damageNTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.Dec 16, 2018 · N4385B · Substantial damageNTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.Dec 16, 2018 · N3165V · Substantial damageNTSB GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.Dec 15, 2018 · N188H · Substantial damageNTSB CEN19LA045Accident · Serious injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.Dec 15, 2018 · N393SX · Substantial damageNTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.Dec 12, 2018 · N5800U · Substantial damageNTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.Dec 10, 2018 · N143GW · Substantial damageNTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.Dec 8, 2018 · N947DS · Substantial damageNTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.Dec 5, 2018 · N839AL · Substantial damageNTSB GAA19CA086Accident · No injuriesData collectionFinal reportCessna 182 · Reno, NVThe airplane’s collision with a bird during a practice instrument approach.Dec 3, 2018 · N9003M · Substantial damageNTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.Nov 30, 2018 · N27838 · Substantial damageNTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.Nov 29, 2018 · N3619M · Substantial damageNTSB ERA19LA057Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Kennesaw, GAThe total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.Nov 29, 2018 · N597CP · Substantial damageNTSB GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.Nov 28, 2018 · N343BZ · Substantial damageNTSB GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.Nov 28, 2018 · N552TC · 2 aircraft · Minor damageNTSB GAA19CA078Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Americus, GAThe pilot's failure to see and avoid a power line during an agricultural application flight.Nov 28, 2018 · N843WA · Substantial damageNTSB ANC19LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Whittier, AKA total loss of engine power for reasons that could not be determined based on the available evidence.Nov 27, 2018 · N7207A · DestroyedNTSB GAA19CA075Accident · No injuriesData collectionFinal reportDarren M. Vinelli Sopwith PUP · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll in gusting tailwind conditions.Nov 26, 2018 · N1916Z · Substantial damageNTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.Nov 23, 2018 · N50340 · Substantial damageNTSB GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.Nov 21, 2018 · N512EA · Substantial damageNTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.Nov 21, 2018 · N579CP · Substantial damageNTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…Nov 20, 2018 · N27LA · Substantial damageNTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.Nov 20, 2018 · N607FT · 2 aircraft · Substantial damageNTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.Nov 19, 2018 · N322JS · 2 aircraft · Substantial damageNTSB WPR19TA037Accident · Minor injuriesClass 3Final reportScottish Series 100 MDL 101 · Lake Pleasant, AZImpact with a lake for undetermined reasons.Nov 17, 2018 · N82696 · Substantial damageNTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.Nov 17, 2018 · N4137W · Substantial damageNTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.Nov 17, 2018 · N111TA · Substantial damageNTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…Nov 17, 2018 · N4817M · Substantial damageNTSB WPR19FA026Accident · 2 fatalClass 2 · FieldFinal reportZenith CH601 · Overgaard, AZThe pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.Nov 16, 2018 · N322JL · Substantial damageNTSB 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 GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.Nov 14, 2018 · N264PC · Substantial damageNTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.Nov 12, 2018 · N4642J · Substantial damageNTSB GAA19CA058Accident · Minor injuriesData collectionFinal reportCessna 172 · Piseco, NYThe pilot’s loss of directional control during landing, which resulted in impact with a snow pile and necessitated a go-around, during which the airplane impacted trees.Nov 12, 2018 · N738VK · Substantial damageNTSB GAA19CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Lihue, HIThe passenger’s improper decision to hold her cell phone outside the helicopter, which resulted in it departing the helicopter and striking the tail rotor.Nov 10, 2018 · N445KP · Substantial damageNTSB GAA19CA054Accident · No injuriesData collectionFinal reportCessna 206 · Boise, IDThe airplane’s impact with a bird during the approach.Nov 10, 2018 · N16HT · Substantial damageNTSB WPR19TA031Accident · No injuriesClass 3Final reportPiper PA28 · Chandler, AZThe student pilot’s failure to maintain a safe distance from the other airplane while taxiing, resulting in a ground collision.Nov 5, 2018 · N9299B · 2 aircraft · Substantial damageNTSB GAA19CA092Accident · No injuriesData collectionFinal reportMaule MX7 · Immokalee, FLThe flight instructor's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with runway signage during the subsequent attempted aborted landing.Nov 5, 2018 · N9225G · Substantial damage