NTSB investigations

3,476 cases where NTSB found Object/animal/substance.

Cases, newest first

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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030220'))
  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 CEN22LA387Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Millville, MNThe pilot’s inadequate inflight planning resulted in impact with a power line.Aug 16, 2022 · N641RZ · Substantial damageNTSB ERA22LA371Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Talladega, ALA collision with a deer during takeoff.Aug 15, 2022 · N1486T · Substantial damageNTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.Aug 14, 2022 · N33125 · Substantial damageNTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.Aug 10, 2022 · N55338 · Substantial damageNTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.Aug 5, 2022 · N722BS · Substantial damageNTSB WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.Aug 5, 2022 · N7485R · Substantial damageNTSB CEN22LA366Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Maynard, IAAn impact with a powerline as a result of an unexpected wind gust.Aug 5, 2022 · N619RB · Substantial damageNTSB WPR22LA291Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Chino, CAThe subsequent delamination of the main rotor blades as a result of an unidentified main rotor blade impact with vegetation during a previous flight by another pilot.Aug 4, 2022 · N833SB · Substantial damageNTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.Aug 4, 2022 · N8865T · Substantial damageNTSB CEN22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Melville, LAThe pilot improperly monitored the operating environment which resulted in a collision with a tree located in the middle of a field.Aug 3, 2022 · N41850 · Substantial damageNTSB CEN22LA350Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marshall, MOThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.Jul 31, 2022 · N458SG · Substantial damageNTSB CEN22LA356Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 150A · Indianola, IAThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.Jul 30, 2022 · N316EB · Minor damageNTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.Jul 30, 2022 · N501MW · DestroyedNTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.Jul 28, 2022 · N719TF · Substantial damageNTSB ERA22LA341Accident · No injuriesClass 4 · LimitedFinal reportGarlick OH-58A+ · Bloomsburg, PAThe pilot's inadequate preflight planning and visual lookout, which resulted in impact with a powerline.Jul 27, 2022 · N132HD · Substantial damageNTSB ERA22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS365 · Hamilton, OHThe pilot’s decision to continue the landing without having visually identified wires that were known to be in the vicinity of the landing zone, which resulted in a collision with the wires while attempting an off-airport landing in dark night visual…Jul 26, 2022 · N520CF · Substantial damageNTSB CEN22LA340Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620A · Stewart, MNThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 25, 2022 · N4651W · Substantial damageNTSB ERA22LA332Accident · Serious injuriesClass 4 · LimitedFinal reportWhitten Robinson Aventura II · Meritt Island, FLThe pilot’s failure to maintain control of the airplane during final approach to land, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and collision with a fence and terrain.Jul 23, 2022 · N709CW · Substantial damageNTSB CEN22LA335Accident · 1 fatalClass 3 · LimitedFinal reportAyres S2R-T34 · Parkin, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering.Jul 23, 2022 · N4046S · DestroyedNTSB CEN22LA371Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T65 · Wyman / Washington, IAThe pilot not maintaining sufficient altitude to clear an obstruction during the aerial application flight.Jul 21, 2022 · N9899 · Substantial damageNTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.Jul 21, 2022 · N1540S · Substantial damageNTSB CEN22LA328Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 · Mount Vernon, ILThe inadequate securement of the cloth fire extinguisher cover, which resulted in it being blown off the fire extinguisher and ingested into the helicopter’s fenestron during the landing.Jul 20, 2022 · N228MT · Substantial damageNTSB ERA22LA347Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Franklin, PAThe pilot’s inadequate visual lookout while flying at a low level over a river, which resulted in a wire strike.Jul 19, 2022 · N203PA · Substantial damageNTSB CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.Jul 19, 2022 · N9688Q · Substantial damageNTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.Jul 17, 2022 · N718TB · Substantial damageNTSB WPR22LA258Accident · 2 fatalClass 3 · LimitedFinal reportEvolution Revolt · Walter Springs, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike and impact with terrain.Jul 17, 2022 · N258MH · DestroyedNTSB ERA22LA325Accident · No injuriesClass 4 · LimitedFinal reportRaytheon 400A · Brunswick, GAAn in-flight collision with a bird.Jul 15, 2022 · N400MX · Substantial damageNTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.Jul 15, 2022 · N2005Z · Substantial damageNTSB WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.Jul 12, 2022 · N43037 · Substantial damageNTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.Jul 10, 2022 · N53JC · Substantial damageNTSB WPR22LA245Accident · Serious injuriesClass 4 · LimitedFinal reportHiller UH-12E · Wenatchee, WAThe pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.Jul 6, 2022 · N130HA · DestroyedNTSB CEN22FA299Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Mount Pleasant, TXThe pilot’s failure to maintain the proper glidepath while on final approach in night visual conditions, which resulted in a collision with trees.Jul 4, 2022 · N1403X · DestroyedNTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.Jul 3, 2022 · N184CB · Substantial damageNTSB CEN22FA288Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Blackwell, TXThe pilot’s failure to maintain proper altitude and clearance during low-level aerial application, resulting in an in-flight collision with power lines.Jun 26, 2022 · N4124D · DestroyedNTSB ERA22LA292Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Market, VAImpact with a fence during an attempted takeoff from a short, uphill turf airstrip.Jun 25, 2022 · N77863 · Substantial damageNTSB ERA22LA290Accident · No injuriesClass 4 · LimitedFinal reportSchweizer 300 C · Boonville, NCThe helicopter’s impact with a non-biological object, which resulted in substantial damage to a main rotor blade.Jun 23, 2022 · N2158T · Substantial damageNTSB ERA22LA283Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A · Charlestown, NHThe pilot’s failure to see and avoid power lines while maneuvering at low altitude.Jun 22, 2022 · N1927A · Substantial damageNTSB CEN22LA287Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Newport, ARThe pilot’s failure to maintain clearance from obstructed terrain during takeoff.Jun 20, 2022 · N42022 · Substantial damageNTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.Jun 14, 2022 · N3553M · Substantial damageNTSB WPR22LA207Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175 · Blackfoot, IDThe pilot’s loss of airplane control during the landing approach which, resulted in an undershoot and collision with a fence.Jun 7, 2022 · N7303M · Substantial damageNTSB WPR22LA201Accident · No injuriesClass 4 · LimitedFinal reportBombardier BD100 1A10 · Hawthorne, CAThe multi-engine pilot's failure to maintain clearance from another airplane during taxi.Jun 7, 2022 · N694PD · 2 aircraft · Minor damageNTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.Jun 7, 2022 · N18244 · Substantial damageNTSB CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.Jun 2, 2022 · N65497 · Substantial damageNTSB CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.Jun 2, 2022 · N65009 · Substantial damageNTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.Jun 1, 2022 · N5007R · Substantial damageNTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.May 30, 2022 · N722PA · Substantial damageNTSB CEN22LA226Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Weiner, ARThe pilot’s failure to maintain clearance from the telephone pole during a low-level aerial application pass.May 27, 2022 · N579LA · DestroyedNTSB ERA22LA238Accident · No injuriesClass 4 · LimitedFinal reportMX MXS · Bealeton, VAAn inflight collision with a bird while conducting low level aerobatics.May 22, 2022 · N104MX · Substantial damageNTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.May 22, 2022 · N85CT · Substantial damageNTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.May 15, 2022 · N17879 · Substantial damage