NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 ANC14CA086Accident · No injuriesData collectionFinal reportMiller Gregory S Bushwacker · Iliamna, AKThe pilot's failure to maintain control on landing, resulting in the collision with terrain.Sep 22, 2014 · N9013U · Substantial damageNTSB WPR14CA387Accident · No injuriesData collectionFinal reportBeech E33A · Las Vegas, NVThe pilot's incorrect engine start procedures, which included improper throttle position and failure to keep the brakes applied, which resulted in a loss of directional control and subsequent collision with a parked airplane.Sep 21, 2014 · N15RJ · Substantial damageNTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.Sep 21, 2014 · N6035S · Substantial damageNTSB ENG14IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GATurbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…Sep 21, 2014 · N669US · No damageNTSB CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.Sep 21, 2014 · N5002E · DestroyedNTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.Sep 20, 2014 · N714TM · Substantial damageNTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.Sep 20, 2014 · N817DH · Substantial damageNTSB ERA14LA450Accident · Serious injuriesLimited investigationFinal reportBarger Jerry L Challenger II · Clarion, PAThe pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…Sep 20, 2014 · N4017C · Substantial damageNTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.Sep 20, 2014 · N3785D · Substantial damageNTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…Sep 20, 2014 · N94SM · Substantial damageNTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.Sep 19, 2014 · N3037H · Substantial damageNTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.Sep 19, 2014 · N3210A · Substantial damageNTSB ERA14LA448Accident · No injuriesLimited investigationFinal reportCessna 172M · Leesburg, FLThe flight instructor’s delayed remedial action and his subsequent loss of directional control during landing on a wet runway for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.Sep 19, 2014 · N13394 · Substantial damageNTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.Sep 19, 2014 · N531KG · DestroyedNTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.Sep 19, 2014 · N749KY · Substantial damageNTSB CEN14LA517Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Cahokia, ILThe pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…Sep 19, 2014 · N115DD · Substantial damageNTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…Sep 19, 2014 · N322QS · Substantial damageNTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.Sep 19, 2014 · N333TB · Substantial damageNTSB ENG14IA028Incident · No injuriesIncident investigationFinal reportAirbus A320 232 · Long Beach, CAThe probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…Sep 18, 2014 · N656JB · Minor damageNTSB ANC14CA084Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cantwell, AKThe pilot's loss of directional control during takeoff from an off-airport site, which resulted in a collision with terrain.Sep 17, 2014 · N1879P · Substantial damageNTSB ERA14FA455Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Fort Gaines, GAThe pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.Sep 16, 2014 · N95480 · Substantial damageNTSB DCA14CA161Accident · No injuriesData collectionFinal reportBoeing 757 223 · Miami, FLThe failure of the first officer to control the airplane pitch after touchdown. Contributing to the accident was the first officers inexperience in the aircraft type.Sep 16, 2014 · N654A · Substantial damageNTSB CEN14CA501Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Longville, MNThe pilot's loss of control during an attempted go-around following a multiple bounce landingSep 16, 2014 · N6081K · DestroyedNTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.Sep 16, 2014 · N6589E · Substantial damageNTSB ANC14CA082Accident · Minor injuriesData collectionFinal reportHelio H 295 · Prospect Creek, AKThe pilot's loss of directional control during takeoff, in gusty and variable wind conditions, resulting in a collision with terrain.Sep 16, 2014 · N50718 · Substantial damageNTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.Sep 15, 2014 · N15833 · Substantial damageNTSB CEN14CA500Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Beaumont, TXThe pilot's loss tail rotor effectiveness while attempting a taxiway side-step during landing. Contributing to the accident was another pilot's failure to ensure the runway was clear before occupying the runway for takeoff.Sep 15, 2014 · N9844N · Substantial damageNTSB WPR14CA375Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Kahului, Maui, HIThe pilot's failure to maintain clearance from the cart while hovering. Contributing to the accident was the failure of ground personnel to remove the cart from the helipad.Sep 14, 2014 · N197BH · Substantial damageNTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.Sep 14, 2014 · N6648V · Substantial damageNTSB ERA14CA452Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's self-induced pressure to land due to the deteriorating weather conditions.Sep 14, 2014 · N21670 · Substantial damageNTSB CEN14CA514Accident · No injuriesData collectionFinal reportStanley Arthur Freeman Zodiac 601XL · Fremont, NEThe pilot's improper landing flare which resulted in a hard landing.Sep 14, 2014 · N710DM · Substantial damageNTSB WPR14CA396Accident · Minor injuriesData collectionFinal reportUltramagic N250 - NO Series · Phoenix, AZThe pilot's failure to maintain aircraft control while landing in downdraft and gusting wind conditions which resulted in striking trees and a subsequent hard landing.Sep 13, 2014 · N59EX · Substantial damageNTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.Sep 13, 2014 · N5132C · Substantial damageNTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…Sep 13, 2014 · 7O-FAB · Minor damageNTSB DCA14CA170Accident · Minor injuriesData collectionFinal reportEmbraer EMB 145XR · Chicago, ILThe tractor driver's failure to give way to the taxiing airplane.Sep 13, 2014 · N16147 · Substantial damageNTSB ANC14CA079Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Susitna, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.Sep 13, 2014 · N959E · Substantial damageNTSB ANC14CA078Accident · No injuriesData collectionFinal reportCessna 180H · Nenana, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, while landing during dark night conditions.Sep 13, 2014 · N2419F · Substantial damageNTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.Sep 12, 2014 · N64AW · Substantial damageNTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.Sep 12, 2014 · N39RD · Substantial damageNTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.Sep 12, 2014 · N719WM · Substantial damageNTSB CEN14CA499Accident · Serious injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Newark, ILThe student pilot did not maintain proper airspeed during the simulated emergency landing and failed to relinquish control to the flight instructor when the flight instructor attempted to intervene, which resulted in the loss of control. Contributing was the…Sep 12, 2014 · N800NW · Substantial damageNTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.Sep 11, 2014 · N142MA · Substantial damageNTSB WPR14CA372Accident · Minor injuriesData collectionFinal reportFound Acft Canada FBA 2C1 · Cascade, IDThe pilot's failure to maintain directional control during landing.Sep 11, 2014 · N500FA · Substantial damageNTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.Sep 11, 2014 · N63835 · Substantial damageNTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.Sep 11, 2014 · N3510Q · Substantial damageNTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…Sep 10, 2014 · N26105 · Substantial damageNTSB CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…Sep 10, 2014 · N711YM · DestroyedNTSB ERA14CA430Accident · Minor injuriesData collectionFinal reportCessna 172M · Watertown, CTThe pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…Sep 9, 2014 · N20469 · Substantial damageNTSB CEN14CA490Accident · Serious injuriesData collectionFinal reportBuckeye Dream · Monee, ILThe pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.Sep 8, 2014 · UNREG · Substantial damageNTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.Sep 8, 2014 · N6693W · Substantial damage