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.

NTSB WPR10FA385Accident · Minor injuriesField investigationFinal reportPiper PA-24-260C · Ridgecrest, CAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management during cruise flight.Aug 5, 2010 · N9365P · Substantial damageNTSB WPR10CA398Accident · Serious injuriesData collectionFinal reportKirkpatrick Buzzard · Lincoln, CAA loss of control due to the mechanical disconnection of an aileron pushrod from its bellcrank as a result of the mechanic's failure to properly secure the pushrod attach hardware. Also causal was the pilot's inadequate preflight inspection.Aug 4, 2010 · N84BS · Substantial damageNTSB ENG10IA045Incident · No injuriesIncident investigationFinal reportBell 430 · Venice, LAThe fracture of the collective servo actuator piston rod resulting from stress corrosion cracking.Aug 4, 2010 · N430CM · Minor damageNTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.Aug 2, 2010 · N5177E · Substantial damageNTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.Aug 2, 2010 · N389HW · Substantial damageNTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.Aug 1, 2010 · N369E · Substantial damageNTSB CEN10IA453Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Mount Pleasant, TXThe failure of an aileron control cable due to a seized idler pulley bearing.Aug 1, 2010 · N4184X · No damageNTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.Jul 30, 2010 · N17965 · Substantial damageNTSB WPR10LA374Accident · Minor injuriesLimited investigationFinal reportLancair 320 · Spokane, WALoss of airplane control due to the asymmetric flap condition.Jul 27, 2010 · N360N · Substantial damageNTSB ERA10IA384Incident · No injuriesIncident investigationFinal reportCessna 402C · San Juan, PRThe airplane manufacturer’s inadequate inspection procedures, resulting in the undetected fatigue cracking of the right upper barrel and trunnion assembly.Jul 27, 2010 · N402VN · Minor damageNTSB ERA10IA378Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe pilot's failure to extend the landing gear prior to landing flare and touchdown.Jul 26, 2010 · N26150 · Minor damageNTSB CEN10CA439Accident · No injuriesData collectionFinal reportBeers Tailwind 10 · Delta, COA loss of control on the ground due to a malfunction of the right brake caliper.Jul 26, 2010 · N375JX · Substantial damageNTSB ERA10LA373Accident · 2 fatalLimited investigationFinal reportNadig Paul K Nadig · Franklin, PAA partial loss of engine power due to the owner’s inadequate fuel system maintenance, which resulted in a collision with trees and subsequent impact with the ground.Jul 24, 2010 · N579PN · Substantial damageNTSB CEN10FA465Accident · 4 fatalField investigationFinal reportCessna U206F · Ludington, MIThe total loss of engine power due to fuel starvation as a result of accumulated debris in the fuel system from an undetermined source. Also causal was the inadequate annual maintenance inspection that did not include inspection of the firewall fuel strainer…Jul 23, 2010 · N82531 · Substantial damageNTSB ENG10IA041Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe cause of the right wing landing light switch fire is undetermined.Jul 18, 2010 · N990DL · Minor damageNTSB ERA10LA357Accident · No injuriesLimited investigationFinal reportBeech 58 · LaGrange, GAThe pilot not allowing sufficient time for fuel spill vapors to dissipate before starting the engine. Contributing to the accident was the inadequate maintenance of the fuel cap.Jul 11, 2010 · N405RW · Substantial damageNTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.Jul 9, 2010 · N2157S · Substantial damageNTSB ERA10FA347Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Fairfield, NJThe pilot's failure to maintain aircraft control during the go-around following a hard landing. Contributing to the accident was the pilot's continuance of an unstabilized final approach and the improper use of flaps during the go-around.Jul 5, 2010 · N764CD · Substantial damageNTSB WPR10CA334Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Tillamook, ORThe certified flight instructor’s selection of an inappropriate landing surface and the loss of engine power as a result of the improper use carburetor heat. Contributing to the accident was the flight instructor's inadequate supervision.Jul 4, 2010 · N2466K · Substantial damageNTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.Jul 2, 2010 · N6802V · Substantial damageNTSB CEN10FA364Accident · 2 fatalField investigationFinal reportBeech F33A · Perry, KSThe failure of the engine driven fuel pump causing a loss of engine power and the pilot's failure to maintain aircraft control resulting in an inadvertent stall. Contributing to the accident was the pilot’s failure to follow the emergency procedures checklist…Jul 1, 2010 · N3071T · Substantial damageNTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.Jun 29, 2010 · N4627J · Substantial damageNTSB CEN10TA355Accident · No injuriesFinal reportLockheed P2V-5 · Broomfield, COThe pilot’s failure to follow published emergency procedures by taxiing to the parking ramp with a known hydraulic system failure. Contributing to the accident was the co-pilot’s improper selection of the bypass position on the emergency nose gear extension…Jun 26, 2010 · N1386C · Substantial damageNTSB CEN10LA351Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Indianapolis, INThe pilot's inability to maintain directional control during landing due to the airplane not being equipped with a steerable or locking tailwheel as required by the airplane's design.Jun 26, 2010 · N469RH · Substantial damageNTSB CEN10CA358Accident · No injuriesData collectionFinal reportCessna 180K · Cahokia, ILThe fatigue failure of the axle's attaching bolts during landing.Jun 26, 2010 · N2785K · Substantial damageNTSB CEN10CA342Accident · Minor injuriesData collectionFinal reportVans RV-12 · Salida, COThe pilot’s incorrect elevator trim setting and his inexperience in the airplane make/model.Jun 24, 2010 · N29CA · Substantial damageNTSB CEN10CA327Accident · Minor injuriesData collectionFinal reportRose-Rhinehart A4-C · Longmont, COA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel valve, resulting a loss of engine power after takeoff. Contributing to the accident was the pilot's overall lack of experience in the airplane make/model.Jun 19, 2010 · N14884 · Substantial damageNTSB ERA10LA330Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Freehold, NYThe failure of the nosegear fork assembly due to fatigue. Contributing to the accident was an inadequate recent annual inspection.Jun 18, 2010 · N832LL · Substantial damageNTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.Jun 18, 2010 · N26EL · Substantial damageNTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.Jun 17, 2010 · N73PC · Substantial damageNTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.Jun 16, 2010 · N196DN · Minor damageNTSB WPR10CA291Accident · No injuriesData collectionFinal reportCessna 188B · Blackfoot, IDA loss of directional control during the landing roll as a result of a worn tail wheel locking mechanism.Jun 14, 2010 · N9357K · Substantial damageNTSB CEN10CA332Accident · No injuriesData collectionFinal reportPiper J3C-65 · Hot Springs, ARA total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.Jun 14, 2010 · N70906 · Substantial damageNTSB CEN10LA315Accident · No injuriesLimited investigationFinal reportBeech 1900D · Denver, COThe pre-existent damage of the right-hand landing gear actuator attachment lug which led to fatigue cracking and eventual overload failure resulting in a collapsed gear upon landing.Jun 12, 2010 · N195GL · Substantial damageNTSB CEN10LA312Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Ankeny, IAThe failure of the stabilator control cable due to wear. Contributing to the accident was the inadequate maintenance inspection of the stabilator control cable.Jun 9, 2010 · N104NW · Substantial damageNTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.Jun 9, 2010 · N9510J · Substantial damageNTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.Jun 4, 2010 · N421KB · Substantial damageNTSB CEN10CA296Accident · Minor injuriesData collectionFinal reportMooney M20M · Port Clinton, OHThe pilot’s delayed decision to abort the landing and his failure to properly reconfigure the airplane during the aborted landing attempt.Jun 4, 2010 · N1054B · Substantial damageNTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.Jun 3, 2010 · N20 · Substantial damageNTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…May 30, 2010 · N801GB · Substantial damageNTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.May 29, 2010 · N23995 · Substantial damageNTSB CEN10LA295Accident · Minor injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Amarillo, TXThe fracture of the fuel pump housing for undetermined reasons.May 29, 2010 · N260PK · DestroyedNTSB WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.May 25, 2010 · N220PE · Substantial damageNTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.May 24, 2010 · N2507M · Substantial damageNTSB WPR10IA256Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Ontario, CAFailure of the airplane’s nose landing gear to extend for undetermined reasons.May 23, 2010 · N925SW · Minor damageNTSB WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.May 21, 2010 · N3633C · Substantial damageNTSB WPR10LA252Accident · Serious injuriesLimited investigationFinal reportLuscombe Silvaire S-LSA-8C · Bakersfield, CAThe pilot's continued operation of the airplane with known mechanical deficiencies, which resulted in a loss of engine power due to fuel starvation.May 21, 2010 · N599LS · Substantial damageNTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.May 21, 2010 · N6630X · Substantial damageNTSB ERA10LA275Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Plattekill, NYThe pilot's failure to place the fuel selector valve in the appropriate position for takeoff resulting in a partial loss of engine power. Contributing to the accident was the pilot's attempted takeoff at a higher than allowed gross weight.May 21, 2010 · N739RK · Substantial damageNTSB CEN10CA262Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · D'Hanis, TXThe pilot's failure to properly set the airplane's flaps prior to takeoff.May 20, 2010 · N3159D · Substantial damage