NTSB investigations
3,633 cases where NTSB found Aircraft systems.
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\", '0102')) 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.
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", '0102')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN11LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Rantoul, ILThe pilot did not use the emergency landing gear extension system, which resulted in a wheels-up landing. Contributing to the accident was the inoperative landing gear power pack motor.NTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.NTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.NTSB WPR11LA267Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lost Hills, CAThe failure of the engine-driven fuel pump, resulting in the loss of all engine power and the pilot's failure to correctly execute an autorotational landing.NTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…NTSB ERA11CA351Accident · No injuriesData collectionFinal reportPerth Amboy Bird CK · New Castle, PAThe pilot's improper use of brakes during the landing rollout.NTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.NTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.NTSB ANC11CA044Accident · No injuriesData collectionFinal reportDouglas DC-6B · Cold Bay, AKThe flight crew's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. Contributing to the accident was the flight crew's diverted attention.NTSB WPR11LA275Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze LX · Montague, CAThe unintended capture of the parachute bridle on a portion of the airframe during the takeoff roll, which resulted in a misinflated or misaligned parachute and an in-flight loss of control.NTSB CEN11IA379Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIThe failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.NTSB ERA11LA326Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Russellville, TNThe pilot’s failure to switch fuel tanks when the fuel was exhausted, which resulted in fuel starvation and a total loss of engine power.NTSB CEN11LA374Accident · Serious injuriesLimited investigationFinal reportMalkin Roy K Searey · Minneapolis, MNThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall. Contributing to the accident was the degraded engine performance due to the improper servicing and maintenance of the fuel system.NTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…NTSB WPR11LA245Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Lake Havasu, AZThe failure of the low pressure switch in the normal landing gear system, which prevented normal operation of that system, and the misrigging of the emergency extension gear release valve, which prevented the system from being depressurized to allow for the…NTSB ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.NTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…NTSB ERA11IA316Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Newburgh, NYThe flight crew did not ensure that the landing gear selector handle was in the full down (extend) position. Contributing to the incident was inadequate checklist information.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11LA357Accident · No injuriesLimited investigationFinal reportCessna T210M · Pueblo, COFailure of the landing gear to fully extend due to a failed o-ring in the nose gear actuator piston and a broken seal in the emergency landing gear extension system.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB CEN11IA341Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COThe fatigue failure of the nose landing gear (NLG) end cap, which resulted in insufficient hydraulic pressure to secure the left main landing gear into the down and locked position. Contributing to the fatigue failure was the NLG end cap’s non-optimum grain…NTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…NTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.NTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB WPR11IA213Incident · No injuriesIncident investigationFinal reportCessna 421B · Truckee, CAFatigue failure of the right flap extend cable during the landing approach.NTSB CEN11CA321Accident · No injuriesData collectionFinal reportChang RV-10 · Minford, OHA loose fuel line fitting, which caused a fuel leak and subsequent in-flight fire.NTSB DCA11IA047Incident · No injuriesIncident investigationFinal reportBoeing 737-7Q8 · Chicago, ILThe flight crew's delayed deployment of the speedbrakes and thrust reversers, resulting in insufficient runway remaining to bring the airplane to a stop. Contributing to the delay in deployment of these stopping devices was the flight crew's inadequate…NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.NTSB CEN11CA282Accident · No injuriesData collectionFinal reportDelf Tim Zenith CH-701 · Davenport, IAThe improper installation of the rudder cable to rudder pedal attachment hardware.NTSB ERA11CA238Accident · No injuriesData collectionFinal reportMooney M20K · Augusta, GAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot’s reported fatigue.NTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.NTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.NTSB ERA11CA237Accident · No injuriesData collectionFinal reportCessna 182A · Lesage, WVA loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.