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 WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.Dec 10, 2011 · N724WD · Substantial damageNTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Dec 10, 2011 · N28870 · Substantial damageNTSB WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.Dec 10, 2011 · N800YD · Substantial damageNTSB CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…Dec 10, 2011 · N999RR · Substantial damageNTSB DCA12CA021Accident · No injuriesData collectionFinal reportBoeing 757-351 · Atlanta, GAthe failure of the captain of N303DQ to maintain a safe clearance from N583NW that was stopped on the taxiway.Dec 9, 2011 · N583NW · 2 aircraft · Substantial damageNTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…Dec 9, 2011 · N421SY · Substantial damageNTSB CEN12CA104Accident · No injuriesData collectionFinal reportCessna 421B · Pampa, TXThe pilot's inadequate aircraft control during landing, which resulted in a hard landing.Dec 9, 2011 · N421CE · Substantial damageNTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…Dec 8, 2011 · N37SH · DestroyedNTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.Dec 8, 2011 · N7138K · Substantial damageNTSB ANC12CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Kaltag, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's self-reported fatigue.Dec 8, 2011 · N300ED · Substantial damageNTSB WPR12LA055Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Davis, CAThe pilot's inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.Dec 7, 2011 · N2466D · Substantial damageNTSB WPR12CA056Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Waipahu, HIThe certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.Dec 7, 2011 · N817AB · Substantial damageNTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…Dec 6, 2011 · HK2308 · Substantial damageNTSB ERA12CA096Accident · Serious injuriesData collectionFinal reportThompson Tommy W Loehle P5151 · Courtland, ALThe airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…Dec 4, 2011 · N212WE · Substantial damageNTSB CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.Dec 4, 2011 · N62WY · No damageNTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.Dec 4, 2011 · N33315 · Substantial damageNTSB CEN12FA098Accident · 4 fatalField investigationFinal reportSocata TB21 · Silverton, COThe non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…Dec 3, 2011 · N25153 · Substantial damageNTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.Dec 3, 2011 · N737ET · Substantial damageNTSB WPR12LA053Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Oakland, CAThe flight crew’s flight into known severe turbulence associated with mountain wave activity.Dec 2, 2011 · N261WN · No damageNTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.Dec 2, 2011 · N295JS · Substantial damageNTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…Dec 2, 2011 · N90QL · DestroyedNTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.Dec 1, 2011 · N2163N · Substantial damageNTSB OPS12IA167Incident · No injuriesIncident investigationFinal reportLearjet 45 · Chicago, ILThe tower local controller did not ensure that the runway was clear of conflict before directing the B737 to cross the runway, and other air traffic control personnel did not effectively intervene when the separation between the two airplanes became…Dec 1, 2011 · N570AM · 2 aircraft · No damageNTSB ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.Dec 1, 2011 · N865JT · Substantial damageNTSB ERA12CA098Accident · No injuriesData collectionFinal reportCessna 172P · Schenectady, NYThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.Dec 1, 2011 · N83PD · Substantial damageNTSB ERA12CA095Accident · No injuriesData collectionFinal reportBell 206L-3 · Wingate, NCThe certified flight instructor did not select an adequate landing site for the practice autorotation.Dec 1, 2011 · N216TV · Substantial damageNTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.Nov 30, 2011 · N36824 · Substantial damageNTSB CEN12LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Fredericksburg, TXThe pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.Nov 30, 2011 · N6735Q · Substantial damageNTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.Nov 30, 2011 · N6485L · Minor damageNTSB ERA12IA090Incident · No injuriesIncident investigationFinal reportCessna 402B · Nantucket, MAThe failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…Nov 29, 2011 · N303PJ · Minor damageNTSB CEN12FA086Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Riverwoods, ILThe pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.Nov 29, 2011 · N59773 · Substantial damageNTSB ANC12FA009Accident · 1 fatalField investigationFinal reportCessna 207 · Chuathbaluk, AKThe pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.Nov 29, 2011 · N1673U · Substantial damageNTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Nov 28, 2011 · N7952A · Substantial damageNTSB CEN12CA093Accident · No injuriesData collectionFinal reportRemos Remos GX · Fort Collins, COThe pilot's improper landing flare.Nov 28, 2011 · N835FS · Substantial damageNTSB ERA12LA087Accident · No injuriesLimited investigationFinal reportSmith Miniplane DSA-4 · Hernando, FLThe pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.Nov 27, 2011 · N1321 · Substantial damageNTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.Nov 26, 2011 · N9408X · Substantial damageNTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.Nov 26, 2011 · N223CD · Substantial damageNTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.Nov 25, 2011 · N816BA · Substantial damageNTSB ERA12CA083Accident · Minor injuriesData collectionFinal reportCessna 162 · Lincoln Park, NJThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control, a runway excursion, and collision with trees.Nov 25, 2011 · N5216J · Substantial damageNTSB CEN12CA089Accident · No injuriesData collectionFinal reportCessna 182L · Branson, MOThe pilot's improper landing flare and inadequate recovery from a bounced landing.Nov 25, 2011 · N42206 · Substantial damageNTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…Nov 24, 2011 · N690SM · DestroyedNTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…Nov 24, 2011 · N534P · Substantial damageNTSB CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.Nov 24, 2011 · N8700M · Substantial damageNTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.Nov 24, 2011 · N203MK · Substantial damageNTSB CEN12CA084Accident · No injuriesData collectionFinal reportCessna 550 · Moline, ILThe pilot's failure to maintain clearance from the parked, unoccupied airplane while taxiing. Contributing to the accident was the guidance provided by the marshaller.Nov 23, 2011 · N544PS · Substantial damageNTSB CEN12CA081Accident · No injuriesData collectionFinal reportFenton Davis DA-2A · Center, TXThe pilot’s inadequate compensation for gusty, crosswind conditions while landing, which resulted in a loss of directional control. Contributing to the accident was the pilot's lack of familiarity with the airplane.Nov 23, 2011 · N808F · Substantial damageNTSB ERA12CA082Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brooksville, FLThe pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.Nov 22, 2011 · N497DA · Substantial damageNTSB CEN12LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Princeton, MNThe inadequate installation of the threaded insert in the No. 2 cylinder spark plug hole by maintenance personnel, which resulted in a loss of engine power during initial climb.Nov 22, 2011 · N6436P · Substantial damageNTSB CEN12CA085Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Bulverde, TXThe pilot's improper glidepath while on final approach.Nov 22, 2011 · N26067 · Substantial damageNTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.Nov 20, 2011 · N131PM · Substantial damage