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 ERA24LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fayetteville, TNA collision with a deer during the takeoff roll.May 31, 2024 · N8536G · Substantial damageNTSB CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.May 30, 2024 · N221RH · Substantial damageNTSB ANC24FA038Accident · 1 fatalClass 3 · FieldFinal reportSchweizer G-164B · Richvale, CAThe pilot’s failure to maintain clearance from a trailer located on the edge of the runway during takeoff. Contributing to the accident was the location of the trailer on the side of the runway.May 28, 2024 · N3629Y · Substantial damageNTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.May 26, 2024 · N33563 · Substantial damageNTSB CEN24LA197Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206 · Butler, MOThe jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.May 25, 2024 · N29173 · DestroyedNTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.May 22, 2024 · N6232H · Substantial damageNTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.May 18, 2024 · N4196K · Substantial damageNTSB CEN24LA191Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Dell City, TXThe pilot’s failure to switch fuel tanks while en route which resulted in the loss of engine power due to fuel starvation.May 18, 2024 · N11NT · Substantial damageNTSB CEN24LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Shreveport, LAThe airplane’s collision with a deer on the runway during landing.May 15, 2024 · N888VL · Substantial damageNTSB WPR24LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Chandler, AZThe pilot’s failure to maintain clearance from obstacles during taxi operations.May 11, 2024 · N428DW · Substantial damageNTSB CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.May 11, 2024 · N3574C · 2 aircraft · Substantial damageNTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.May 11, 2024 · N815CD · Substantial damageNTSB WPR24LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna T206H · Halls Crossing, UTThe airplane’s collision with a tree during an aborted landing. Contributing to the accident was the airplane’s reported brake malfunction for undetermined reasons.May 2, 2024 · N50101 · Substantial damageNTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.May 2, 2024 · N42PL · Substantial damageNTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.May 1, 2024 · N8515G · Substantial damageNTSB CEN24LA177Accident · No injuriesClass 4 · LimitedFinal reportZenith CH-750 · Seymour, INThe flight instructor’s failure to maintain clearance from a fence during a takeoff attempt.Apr 30, 2024 · N750EE · Substantial damageNTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…Apr 27, 2024 · N601DR · DestroyedNTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.Apr 9, 2024 · N243MH · Substantial damageNTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.Mar 29, 2024 · N910GX · Substantial damageNTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.Mar 21, 2024 · N5236R · Substantial damageNTSB ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.Mar 18, 2024 · N102SU · Substantial damageNTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.Mar 17, 2024 · N4425L · Substantial damageNTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.Mar 16, 2024 · N295P · Substantial damageNTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.Mar 15, 2024 · N43373 · Substantial damageNTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.Mar 14, 2024 · N6300Q · Substantial damageNTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.Mar 5, 2024 · N853MB · Substantial damageNTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.Mar 1, 2024 · N1057R · Substantial damageNTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.Feb 16, 2024 · N9160H · Substantial damageNTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.Feb 12, 2024 · N87965 · Substantial damageNTSB CEN24LA114Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Wayside, TXThe student pilot’s improper fuel management during the cross-country flight, which resulted in a total loss of engine power due to fuel starvation.Feb 9, 2024 · N7586R · Substantial damageNTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.Feb 5, 2024 · N2150G · Substantial damageNTSB ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.Feb 1, 2024 · N521LS · Substantial damageNTSB CEN24LA110Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Taurus · Waller, TXThe failure of both pilots to see and avoid one another while maneuvering, which resulted in a mid-air collision.Feb 1, 2024 · N984TP · 2 aircraft · Substantial damageNTSB CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.Jan 29, 2024 · N315GW · Substantial damageNTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.Jan 21, 2024 · N295AE · DestroyedNTSB ERA24LA092Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · New Smyrna Beach, FLA failure of the right brake during taxi, which resulted in a taxiway excursion and collision with a tree.Jan 20, 2024 · N321EP · Substantial damageNTSB WPR24LA068Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · Carson City, NVAirport personnel’s failure to properly prioritize their response actions, including updating the airport’s automated weather observation system recording in a timely manner to notify incoming pilots of a runway closure, which resulted in an airplane striking…Jan 8, 2024 · N421TP · Substantial damageNTSB CEN24LA084Accident · Serious injuriesClass 4 · LimitedFinal reportSlipStream International Genesis · Buffalo, MOThe student pilot’s failure to maintain control of the airplane during the crosswind landing, which resulted in the airplane drifting off the left side of the runway and into trees.Jan 7, 2024 · N8704R · Substantial damageNTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.Jan 6, 2024 · N712DG · DestroyedNTSB WPR24LA069Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Whitefish, MTThe failure of the airport authorities to renew the airport closure NOTAM for the airport. Contributing to the accident, was the pilot’s inability to see the runway closure sign.Dec 23, 2023 · N43415 · Substantial damageNTSB DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.Dec 20, 2023 · N8830Q · Minor damageNTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.Dec 19, 2023 · N8514F · Substantial damageNTSB CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Dec 18, 2023 · N66RC · Substantial damageNTSB ERA24LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Newport News, VAAn inflight collision with a bird during initial climb.Dec 11, 2023 · N733QJ · Substantial damageNTSB ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.Dec 10, 2023 · N1707Q · Substantial damageNTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.Dec 8, 2023 · N1880P · DestroyedNTSB WPR24LA092Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calexico, CAThe pilot's failure to maintain clearance from power lines during an aerial application flight.Dec 6, 2023 · N422DX · Substantial damageNTSB ERA24LA057Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Social Circle, GAAn encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.Dec 5, 2023 · N53AA · Substantial damageNTSB DCA24LA034Incident · Minor injuriesClass 3 · LimitedFinal reportBoeing 717 · Kahului, HIThe captain did not verify that the tow tractor had exited the area in front of the airplane before taxiing for departure. Contributing factors were the dark conditions and the absence of an illuminated hazard beacon on the tow tractor, which reduced its…Nov 30, 2023 · N494HA · Minor damageNTSB WPR24LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Watsonville, CAAn in-flight collision with a bird while in the initial climb.Nov 29, 2023 · N6212F · Substantial damage