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 CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.Jul 27, 2011 · N7578 · Substantial damageNTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.Jul 26, 2011 · N8525L · Substantial damageNTSB ERA11CA423Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Quinton, VAThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 26, 2011 · N81917 · Substantial damageNTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.Jul 26, 2011 · N41MK · Substantial damageNTSB CEN11CA519Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · Colorado Springs, COThe pilot's failure to maintain proper approach speed and his inadequate recovery from a bounced landing.Jul 26, 2011 · N1277K · Substantial damageNTSB CEN11CA516Accident · Serious injuriesData collectionFinal reportCessna 150F · Harbor Beach, MIThe pilot's delay in using carburetor heat while operating in carburetor icing conditions, resulting in carburetor ice and subsequent partial loss of engine power.Jul 26, 2011 · N3050X · Substantial damageNTSB WPR11LA356Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Brewster, WAThe pilot did not maintain main rotor rpm while hovering in gusting wind conditions.Jul 25, 2011 · N855TC · Substantial damageNTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.Jul 25, 2011 · N5663 · Substantial damageNTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…Jul 25, 2011 · N1279T · Substantial damageNTSB CEN11LA506Accident · No injuriesLimited investigationFinal reportGottschalk John R John 1 · Oshkosh, WIThe pilot's inadequate preflight planning, which led to the power required exceeding the power available and resulted in a loss of lift and subsequent hard landing.Jul 25, 2011 · N559RD · Substantial damageNTSB CEN11FA507Accident · 1 fatalField investigationFinal reportSikorsky UH-34D · Wilton, IAThe inadequate performance planning by the pilot that resulted in reduced climb capability while transitioning to an out-of-ground effect hover with a left pedal turn.Jul 25, 2011 · N3880J · Substantial damageNTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.Jul 25, 2011 · N81BF · Substantial damageNTSB WPR11CA368Accident · No injuriesData collectionFinal reportCessna R172K · Sandy, ORThe pilot's improper flare which resulted in a hard landing.Jul 24, 2011 · N758TT · Substantial damageNTSB WPR11CA347Accident · No injuriesData collectionFinal reportCessna 182B · Sandy, ORThe pilot's failure to maintain adequate clearance between the airplane and ground obstacles.Jul 24, 2011 · N8426T · Substantial damageNTSB ERA11LA418Accident · No injuriesLimited investigationFinal reportFloyd Joseph B RV6 · Hartford, KYA loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.Jul 24, 2011 · N164BF · Substantial damageNTSB ERA11CA419Accident · No injuriesData collectionFinal reportCessna 177 · Americus, GAThe CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jul 24, 2011 · N30214 · Substantial damageNTSB CEN11FA500Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Rantoul, ILThe pilot did not maintain airplane control during takeoff with approaching thunderstorms. Contributing to the accident was the pilot's decision to depart into adverse weather conditions.Jul 24, 2011 · N46TW · Substantial damageNTSB CEN11CA518Accident · No injuriesData collectionFinal reportCessna 180D · Oscoda, MIThe pilot's failure to retract the landing gear before a water landing. Contributing to the accident was the pilot's failure to use a checklist.Jul 24, 2011 · N6425X · Substantial damageNTSB ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.Jul 24, 2011 · N7304S · Substantial damageNTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.Jul 23, 2011 · N536BB · Substantial damageNTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.Jul 23, 2011 · N34299 · Substantial damageNTSB WPR11CA357Accident · No injuriesData collectionFinal reportCessna 175 · Greer, AZThe pilot’s improper flare and inadequate recovery from a bounced landing which resulted in a nose gear collapse.Jul 23, 2011 · N9402B · Substantial damageNTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.Jul 23, 2011 · N8318K · Substantial damageNTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.Jul 23, 2011 · N869BC · Substantial damageNTSB ERA11LA416Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hinesville, GAThe total loss of engine power due to the improper installation of the carburetor air filter by maintenance personnel, which resulted in the filter becoming dislodged and obstructing the carburetor. Contributing to the accident was the pilot did not maintain…Jul 23, 2011 · N5191X · Substantial damageNTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…Jul 23, 2011 · N122HB · Substantial damageNTSB ERA11FA413Accident · 1 fatalField investigationFinal reportMoyes Dragonfly · Ridgely, MDAn in-flight loss of control for reasons that could not be determined during postaccident examinations.Jul 23, 2011 · N402HA · Substantial damageNTSB ERA11CA420Accident · No injuriesData collectionFinal reportDehavilland Tiger Moth DH 82A · Rockland, METhe pilot's failure to maintain a proper approach path during landing.Jul 23, 2011 · N8872 · Substantial damageNTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.Jul 23, 2011 · N1149D · Substantial damageNTSB CEN11CA547Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Poplar Grove, ILThe pilot's decision to not use all available runway length and his failure to abort the takeoff.Jul 23, 2011 · N2844K · Substantial damageNTSB CEN11CA526Accident · No injuriesData collectionFinal reportPiper PA-36-375 · Cambridge, NEThe pilot's failure to reset the engine's mixture control lever to the full rich position prior to takeoff.Jul 23, 2011 · N3963E · Substantial damageNTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.Jul 23, 2011 · N915BW · Substantial damageNTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.Jul 23, 2011 · N118TV · Substantial damageNTSB CEN11LA527Accident · No injuriesLimited investigationFinal reportSnow Quickie 2 · Ashtabula, OHThe incorrect propeller pitch and lower-than-expected engine speed that did not allow the airplane to attain a proper climb rate during takeoff, and the subsequent hard landing that occurred when the pilot reduced power.Jul 22, 2011 · N240JS · Substantial damageNTSB ERA11FA412Accident · 2 fatalField investigationFinal reportCessna 182S · Erwin, NCThe pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.Jul 21, 2011 · N23739 · Substantial damageNTSB CEN11CA497Accident · No injuriesData collectionFinal reportGrumman Schweizer G-164A · North English, IAThe pilot's improper flare which resulted in a hard landing.Jul 21, 2011 · N5439 · Substantial damageNTSB WPR11CA339Accident · No injuriesData collectionFinal reportBell 47G-5 · Watsonville, CAThe pilot's failure to maintain clearance from a pole while maneuvering during an aerial application flight.Jul 20, 2011 · N1375X · Substantial damageNTSB ERA11LA415Accident · 2 fatalLimited investigationFinal reportPolaris Polar Star · Dewees Island, SCThe non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…Jul 20, 2011 · UNREG · Substantial damageNTSB ERA11LA409Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Dayton, NJThe pilot's inadequate compensation for wind during an out-of-ground-effect hover, which resulted in a loss of control due to settling with power and loss of tail rotor effectiveness.Jul 20, 2011 · N83509 · Substantial damageNTSB ERA11CA410Accident · Minor injuriesData collectionFinal reportSky International A-1C-180 · Fryeburg, METhe pilot's failure to maintain directional control while landing in gusty wind conditions.Jul 20, 2011 · N52LK · Substantial damageNTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.Jul 20, 2011 · N2056S · Substantial damageNTSB CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…Jul 20, 2011 · N1883D · Substantial damageNTSB CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.Jul 20, 2011 · N343A · Substantial damageNTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.Jul 20, 2011 · N3656X · Substantial damageNTSB WPR11CA486Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Brigham City, UTThe glider pilot did not take timely action to locate a safe outlanding area after entering an area where atmospheric lift was not sufficient to maintain soaring flight.Jul 19, 2011 · N797V · Substantial damageNTSB WPR11CA447Accident · No injuriesData collectionFinal reportCessna 120 · Pendleton, ORThe pilot's excessive brake application while landing on rough terrain.Jul 19, 2011 · N1705N · Substantial damageNTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.Jul 19, 2011 · N601FD · Substantial damageNTSB WPR11CA341Accident · No injuriesData collectionFinal reportCliff Starduster II SA300 · San Jose, CAThe pilot's decision to not follow the designated taxiway, and failure to maintain clearance from a sign.Jul 19, 2011 · N411TM · Substantial damageNTSB CEN11CA495Accident · No injuriesData collectionFinal reportCessna A188B · Greenstown, INThe pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.Jul 19, 2011 · N4725R · Substantial damageNTSB ANC11CA066Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Kantishna, AKThe pilot's inadequate decision to make contact with an unsuitable landing surface, resulting in a nose over.Jul 19, 2011 · N5043N · Substantial damage