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 ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…Jan 28, 2015 · N54380 · 2 aircraft · Minor damageNTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…Jan 28, 2015 · N708JE · Substantial damageNTSB CEN15CA130Accident · No injuriesData collectionFinal reportCessna 310B · Rothville, MOThe pilot's inadequate preflight planning and fuel management which resulted in fuel exhaustion.Jan 28, 2015 · N131X · Substantial damageNTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.Jan 27, 2015 · N805ER · Substantial damageNTSB CEN15FA119Accident · 1 fatalField investigationFinal reportCessna 182L · Owen, WIThe flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…Jan 26, 2015 · N3181R · Substantial damageNTSB CEN15CA125Accident · Minor injuriesData collectionFinal reportCessna 182C · Fort Morgan, COThe pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.Jan 26, 2015 · N8997T · Substantial damageNTSB ERA15LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fernandina Beach, FLThe pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.Jan 25, 2015 · N10616 · Substantial damageNTSB CEN15LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Routt County, COThe pilot’s intentional flight into terrain.Jan 25, 2015 · N8368U · Substantial damageNTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.Jan 23, 2015 · N35560 · Substantial damageNTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.Jan 22, 2015 · N465JA · DestroyedNTSB CEN15CA121Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper landing technique which resulted in a hard landing and subsequent nose landing gear collapse.Jan 22, 2015 · N6300Q · Substantial damageNTSB WPR15FA088Accident · 2 fatalField investigationFinal reportBeech 36 · Mountain Pass, CAAn in-flight loss of control for reasons that could not be determined based on available information.Jan 21, 2015 · N999CJ · DestroyedNTSB CEN15LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Goodland, KSThe pilot's improper fuel management and failure to conduct the engine failure emergency procedures and his improper conduct of the forced landing, which resulted in fuel starvation, a total loss of engine power, and the subsequent high-energy impact with…Jan 21, 2015 · N66906 · Substantial damageNTSB ANC15LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Jan 21, 2015 · N2580D · Substantial damageNTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.Jan 19, 2015 · N104SA · Substantial damageNTSB CEN15LA111Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Lowell, MIThe student pilot’s loss of airplane control during a go-around after not applying sufficient engine power.Jan 19, 2015 · N7854U · Substantial damageNTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…Jan 19, 2015 · N979DC · Substantial damageNTSB WPR15LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Flagstaff, AZThe pilot's improper landing flare and loss of airplane control, which resulted in a hard landing and the subsequent failure of the nose landing gear.Jan 18, 2015 · N3685W · Substantial damageNTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…Jan 16, 2015 · N232LT · Substantial damageNTSB ERA15FA103Accident · 1 fatalField investigationFinal reportLuscombe 8 · Fort Valley, GAThe flight instructor’s failure to maintain airspeed during an approach with a simulated engine failure, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.Jan 16, 2015 · N1745K · Substantial damageNTSB ERA15FA102Accident · 2 fatalField investigationFinal reportSchmidt Albert D Aventura II · Sebring, FLThe pilot's failure to maintain control while maneuvering at low altitude, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jan 16, 2015 · N511DS · Substantial damageNTSB ERA15CA106Accident · No injuriesData collectionFinal reportCessna 172L · New Castle, PAPilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.Jan 16, 2015 · N7079Q · Substantial damageNTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.Jan 15, 2015 · N5443Q · Substantial damageNTSB CEN15LA109Accident · No injuriesLimited investigationFinal reportCessna 182R · Santa Fe, NMThe pilot’s failure to remove ice from the airplane’s surfaces before departure, which resulted in the airplane’s inability to attain sufficient airspeed shortly after takeoff, the subsequent exceedance of the airplane’s critical angle-of-attack, and an…Jan 15, 2015 · N9611H · Substantial damageNTSB ERA15FA099Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Beach, FLThe pilot's failure to maintain control of the airplane while operating under visual flight rules (VFR) in night, instrument meteorological conditions, likely due to spatial disorientation. Contributing to the outcome was the radar controller's failure to…Jan 14, 2015 · N757ZM · Substantial damageNTSB ERA15CA100Accident · Minor injuriesData collectionFinal reportShannon William RV6A · Pikeville, KYThe pilot's failure to maintain airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to obtain a preflight weather briefing, and his subsequent flight into icing conditions, which resulted in…Jan 14, 2015 · N32SN · Substantial damageNTSB CEN15LA107Accident · Serious injuriesLimited investigationFinal reportCessna 210J · Dodge City, KSThe loss of engine power on approach due to fuel exhaustion, which resulted from the pilot's improper preflight fuel planning and inspection.Jan 14, 2015 · N3320S · Substantial damageNTSB ERA15CA116Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Deland, FLThe pilot's inadequate preflight weather planning and decision to land in an area with known convective wind gusts, which resulted in a loss of control and subsequent hard landing.Jan 12, 2015 · N5033S · Substantial damageNTSB WPR15LA084Accident · 1 fatalLimited investigationFinal reportBruct J Myers RV-9A · Prineville, ORThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.Jan 11, 2015 · N8080S · DestroyedNTSB CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.Jan 11, 2015 · N82828 · DestroyedNTSB WPR15LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.Jan 10, 2015 · N2229C · Substantial damageNTSB ERA15LA097Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe student pilot’s failure to maintain airplane control after engine start, which resulted in a ground collision with trees.Jan 10, 2015 · N89921 · Substantial damageNTSB ERA15FA096Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Catano, PRThe student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…Jan 10, 2015 · N348VH · DestroyedNTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…Jan 9, 2015 · N383GM · Substantial damageNTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…Jan 9, 2015 · N7ZL · Substantial damageNTSB CEN15LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pontiac, ILThe flight instructor’s loss of directional control during an attempted go-around with a crosswind. Contributing to the accident was the loss of engine power for reasons that could not be determined during examination of the engine.Jan 9, 2015 · N2871S · Substantial damageNTSB ERA15CA095Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, METhe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.Jan 7, 2015 · N70037 · Substantial damageNTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.Jan 6, 2015 · N246JT · Substantial damageNTSB CEN15LA099Accident · No injuriesLimited investigationFinal reportCessna 195B · Llano, TXThe pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.Jan 6, 2015 · N2125C · Substantial damageNTSB CEN15CA128Accident · Serious injuriesData collectionFinal reportBurton Calidus · Grand Junction, COThe pilot's failure to maintain clearance with terrain that was along the planned route of flight.Jan 6, 2015 · N50NE · Substantial damageNTSB CEN15CA097Accident · No injuriesData collectionFinal reportCessna 172M · Marquette, MIThe pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.Jan 5, 2015 · N6591H · Substantial damageNTSB WPR15LA077Accident · No injuriesLimited investigationFinal reportCessna 172D · Fresno, CAThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Jan 4, 2015 · N2948U · Substantial damageNTSB WPR15CA078Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Sedona, AZThe pilot's loss of directional control during the landing roll.Jan 4, 2015 · N3811M · Substantial damageNTSB WPR15CA076Accident · No injuriesData collectionFinal reportBeech 35 A33 · Angwin, CAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, and collision with a fence.Jan 4, 2015 · N907Q · Substantial damageNTSB CEN15LA098Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Parker City, INThe pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.Jan 4, 2015 · N349EA · Substantial damageNTSB WPR15CA074Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · San Luis Obispo, CAThe accidental application of the brakes by the passenger during landing roll which resulted in the airplane nosing over.Jan 3, 2015 · N171L · Substantial damageNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damageNTSB ERA15CA118Accident · No injuriesData collectionFinal reportDayton A Babcock Storm · Eustis, FLThe pilot's failure to maintain adequate spacing from the preceding aircraft during a formation landing, resulting in an inadvertent "prop wash" encounter, loss of control, and impact with terrain.Jan 2, 2015 · N516VB · Substantial damageNTSB ERA15CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Barranquitas, PRThe pilot's failure to maintain control of the helicopter while landing which resulted in a tailrotor ground strike and collision with terrain.Jan 2, 2015 · N3183T · Substantial damageNTSB WPR15FA072Accident · 2 fatalField investigationFinal reportBell 206 · Benson, AZThe pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…Jan 1, 2015 · N57AW · Destroyed