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 WPR11FA335Accident · 3 fatalField investigationFinal reportMooney M20C · Grace, IDThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.Jul 18, 2011 · N6855N · Substantial damageNTSB WPR11FA334Accident · Serious injuriesField investigationFinal reportPiper PA-12 · Joshua Tree, CAThe pilot's decision to conduct low altitude flight at a high density altitude and into a box canyon, which resulted in the airplane colliding with rising terrain when its climb capability was exceeded.Jul 18, 2011 · N7510H · Substantial damageNTSB WPR11FA333Accident · 2 fatalField investigationFinal reportDavidson Zenith Stol CH701 · Glendale, ORA total loss of engine power due to fuel starvation and the pilot’s subsequent failure to maintain airplane control during the forced landing. Contributing to the accident was the pilot’s failure to ensure that the fuel valves were in the correct position for…Jul 18, 2011 · N701RD · Substantial damageNTSB ERA11FA406Accident · 1 fatalField investigationFinal reportMooney M20K · Augusta, GAThe pilot’s decision to fly the airplane after maintenance personnel advised him that the airplane should not be flown because the pilot provided an incorrect propeller for installation and the subsequent failure of the propeller attachment bolts and the…Jul 18, 2011 · N777CV · Substantial damageNTSB CEN11LA483Accident · Serious injuriesLimited investigationFinal reportMooney M20S · San Antonio, TXThe pilot’s failure to maintain aircraft control during the go-around maneuver.Jul 18, 2011 · N442PT · Substantial damageNTSB WPR11FA331Accident · 2 fatalField investigationFinal reportMooney M20F · Winslow, AZA loss of engine power due to fuel system contamination, and the pilot’s subsequent failure to maintain an adequate airspeed, which resulted in a loss of control.Jul 17, 2011 · N3534X · Substantial damageNTSB WPR11CA337Accident · No injuriesData collectionFinal reportCessna 172N · Porthill, IDThe pilot's failure to maintain clearance from a pole.Jul 17, 2011 · N733BT · Substantial damageNTSB ERA11LA405Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Matinicus Island, METhe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 17, 2011 · N910TA · Substantial damageNTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…Jul 17, 2011 · N92770 · Substantial damageNTSB WPR11CA338Accident · Serious injuriesData collectionFinal reportRolladen Schneider OHG LS-3-17 · Adelanto, CAThe pilot's incorrect use of the flap control pitch control recovery which resulted in an aerodynamic stall.Jul 16, 2011 · N84AM · Substantial damageNTSB WPR11CA336Accident · No injuriesData collectionFinal reportStearman C3-B · Spokane, WAThe pilot's failure to maintain directional control on landing. Contributing to the accident was the touch down in a slide-slip.Jul 16, 2011 · N3440 · Substantial damageNTSB ERA11LA403Accident · Serious injuriesLimited investigationFinal reportMurphy Elite · Batavia, NYThe pilot's failure to maintain control of the airplane during takeoff.Jul 16, 2011 · N113SM · Substantial damageNTSB CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.Jul 16, 2011 · N50408 · Substantial damageNTSB CEN11CA486Accident · Minor injuriesData collectionFinal reportHamlin John D CH701 · Paxton, ILThe pilot's decision to takeoff with a tailwind in high density altitude conditions.Jul 16, 2011 · N9040W · Substantial damageNTSB ERA11FA401Accident · 1 fatalField investigationFinal reportSlingsby Capstan Type 49B · Hollywood, MDThe glider pilot’s improper response to the “check spoilers” signal from the tow pilot. Contributing to the accident was the glider pilot’s failure to confirm that the spoilers were closed and locked before takeoff, and the glider copilot’s improper crew…Jul 15, 2011 · N7475 · Substantial damageNTSB ERA11CA407Accident · No injuriesData collectionFinal reportCessna 180J · Schlater, MSThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion.Jul 15, 2011 · N9996N · Substantial damageNTSB ERA11CA404Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Adams, NYThe pilot's loss of directional control during landing.Jul 15, 2011 · N7516R · Substantial damageNTSB ERA11CA402Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crystal River, FLThe pilot's failure to attain the proper touchdown point, and his improper decision to perform a go-around with a tailwind and insufficient runway remaining.Jul 15, 2011 · N18PE · Substantial damageNTSB CEN11LA481Accident · Serious injuriesLimited investigationFinal reportDegraw Rhino II · Jackson, MIThe pilot did not maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.Jul 15, 2011 · N122DG · Substantial damageNTSB WPR11CA329Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Albany, ORThe pilot's inadequate preflight inspection and failure to ensure the fuel cap was secured after refueling, which resulted in a total loss of engine power due to fuel exhaustion.Jul 14, 2011 · N16TP · Substantial damageNTSB WPR11CA328Accident · No injuriesData collectionFinal reportTaylorcraft F-22 · Payson, AZThe pilot's selection of a wrong runway to practice touch-and-go takeoffs and landings.Jul 14, 2011 · N191TC · Substantial damageNTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.Jul 14, 2011 · N132EV · 2 aircraft · Substantial damageNTSB CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…Jul 14, 2011 · N1539Q · Substantial damageNTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.Jul 14, 2011 · N7709Z · Substantial damageNTSB WPR11CA327Accident · Minor injuriesData collectionFinal reportCessna 150J · Wheatland, WYThe pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to continue flight with known equipment deficiencies.Jul 13, 2011 · N60060 · Substantial damageNTSB ANC11CA064Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Cordova, AKThe pilot's failure to maintain sufficient airspeed during approach, resulting in an aerodynamic stall, and collision with terrain.Jul 13, 2011 · N9255D · Substantial damageNTSB WPR11LA325Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wenatchee, WAThe pilot's failure to maintain control while hovering out of ground effect at low altitude, which resulted in the helicopter settling into trees.Jul 12, 2011 · N3623Z · Substantial damageNTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.Jul 11, 2011 · N6YM · Substantial damageNTSB WPR11CA322Accident · Minor injuriesData collectionFinal reportDova Aircraft Sro DV-1 Skylark · Placerville, CAThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Jul 11, 2011 · N3503C · Substantial damageNTSB WPR11CA330Accident · No injuriesData collectionFinal reportCessna 210-5(205) · McKenzie Bridge, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 10, 2011 · N8343Z · Substantial damageNTSB WPR11CA321Accident · Minor injuriesData collectionFinal reportLeineke Walter L Thorp T-211 · Cedar City, UTThe pilot's misjudgment of the fuel consumption, which lead to fuel exhaustion. Contributing to the accident was the pilot's lack of experience in the accident airplane.Jul 10, 2011 · N2075U · Substantial damageNTSB ERA11LA393Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Ormond Beach, FLThe loss of engine power due to fuel starvation, which resulted from the flight instructor's inadequate in-flight fuel management.Jul 10, 2011 · N9202C · Substantial damageNTSB ANC11FA062Accident · No injuriesField investigationFinal reportCessna U206 · Port Alsworth, AKThe pilot’s failure to see and avoid the approaching airplane. Contributing to the accident was that the pilot’s failure to listen to radio position reports from the other airplane on the common traffic advisory frequency and the absence of any forward-facing…Jul 10, 2011 · N2186F · 2 aircraft · Minor damageNTSB ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.Jul 10, 2011 · N2318M · Substantial damageNTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…Jul 9, 2011 · N111XN · Substantial damageNTSB ERA11FA391Accident · 7 fatalField investigationFinal reportCessna 421C · Demopolis, ALThe pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…Jul 9, 2011 · N692TT · Substantial damageNTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.Jul 9, 2011 · N3344A · Substantial damageNTSB CEN11LA472Accident · No injuriesLimited investigationFinal reportCessna 150J · Lacassine, LAA total loss of engine power due to fuel exhaustion, as a result of the pilot's improper fuel planning.Jul 9, 2011 · N50575 · Substantial damageNTSB CEN11LA466Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-1 · Benton, KSThe pilot did not maintain sufficient airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and spin.Jul 9, 2011 · N22DH · Substantial damageNTSB CEN11FA469Accident · 1 fatalField investigationFinal reportBowie Richard Sonerai II · Dudley, MOFuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.Jul 9, 2011 · N113RB · Substantial damageNTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.Jul 9, 2011 · N42333 · Substantial damageNTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.Jul 9, 2011 · N3266R · Substantial damageNTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…Jul 9, 2011 · N9129M · Substantial damageNTSB WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.Jul 8, 2011 · N4901Z · Substantial damageNTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.Jul 8, 2011 · N591CC · Substantial damageNTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.Jul 8, 2011 · N8721C · Substantial damageNTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…Jul 8, 2011 · N7759M · Substantial damageNTSB WPR11LA315Accident · No injuriesLimited investigationFinal reportBeech V35B · Oljato, UTThe pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.Jul 7, 2011 · N1735W · Substantial damageNTSB WPR11CA323Accident · No injuriesData collectionFinal reportTL Ultralight Sro Stingsport · Soda Springs, IDThe pilot's improper landing flare and failure to maintain directional control during the landing.Jul 7, 2011 · N545N · Substantial damageNTSB ANC11LA060Accident · Serious injuriesLimited investigationFinal reportSonex / John D. McCarter Waiex · Sterling, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall following a loss of engine power for undetermined reasons.Jul 7, 2011 · N18YX · Substantial damage