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 GAA18CA385Accident · No injuriesData collectionFinal reportPiper PA18 · Anchorage, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 28, 2018 · N4714Y · Substantial damageNTSB CEN18LA241Accident · No injuriesLimited investigationFinal reportCessna T210 · Pocahontas, ARThe pilot's excessive use of wheel brakes while landing, which resulted in both brakes locking up, a loss of directional control, a runway excursion, and a nose over.Jun 28, 2018 · N6386C · Substantial damageNTSB ANC18LA049Accident · No injuriesClass 3 · LimitedFinal reportLearjet 60 · Salt Lake City, UTThe flight crew’s failure to fully disengage the parking brake before taxi, which resulted in a brake fire.Jun 26, 2018 · N57 · Substantial damageNTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.Jun 25, 2018 · N52584 · Substantial damageNTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…Jun 24, 2018 · N3896P · Substantial damageNTSB ANC18LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe failure of the brake line tube due to an improper flare.Jun 23, 2018 · N3125D · Substantial damageNTSB ERA18FA174Accident · 1 fatalField investigationFinal reportCessna 172 · Diamondhead, MSThe student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.Jun 22, 2018 · N7239Q · DestroyedNTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.Jun 20, 2018 · N9130T · Substantial damageNTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.Jun 19, 2018 · N3002X · Substantial damageNTSB CEN18LA230Accident · No injuriesLimited investigationFinal reportCessna TR182 · Beloit, KSThe mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.Jun 18, 2018 · N756SW · Substantial damageNTSB GAA18CA361Accident · No injuriesData collectionFinal reportRaytheon A36 · Lakeview, ARThe pilot’s failure to extend the landing gear before landing, which resulted in a propeller strike, followed by an aborted landing and a subsequent hard, precautionary landing.Jun 17, 2018 · N174DM · Substantial damageNTSB GAA18CA355Accident · No injuriesData collectionFinal reportPiper PA18 · Salcha, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 17, 2018 · N9098D · Substantial damageNTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.Jun 17, 2018 · N6107R · Substantial damageNTSB WPR18LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Page, AZThe failure of the airplane’s nose wheel steering/centering mechanism, which resulted in a loss of directional control and subsequent runway excursion.Jun 16, 2018 · N621PG · Substantial damageNTSB GAA18CA351Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot’s inability to maintain directional control during the landing roll due to a flat tire.Jun 15, 2018 · N9964X · Substantial damageNTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.Jun 14, 2018 · N322HA · Substantial damageNTSB WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.Jun 14, 2018 · N2165 · Substantial damageNTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…Jun 14, 2018 · N56213 · Substantial damageNTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.Jun 13, 2018 · N82303 · Substantial damageNTSB GAA18CA379Accident · No injuriesData collectionFinal reportDan Jelinek Backcountry Supercub · Douglas, WYThe pilot’s overcorrection with rudder during takeoff, which resulted in a loss of directional control.Jun 11, 2018 · N7455 · Substantial damageNTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.Jun 11, 2018 · N4198S · Substantial damageNTSB ANC18FA044Accident · 2 fatalClass 2 · FieldFinal reportPiper PA18 · Sitka, AKThe pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.Jun 9, 2018 · N1203A · Substantial damageNTSB CEN18LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Baton Rouge, LAThe improper insulation of the anticollision light wiring, which resulted in the ignition of combustible fuel vapors in the outboard section of the right wing; the source of the fuel leak could not be determined due to fire damage.Jun 8, 2018 · N190RS · Substantial damageNTSB GAA18CA328Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arlington, WAThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 7, 2018 · N3202H · Substantial damageNTSB GAA18CA362Accident · No injuriesData collectionFinal reportPiper PA18 · Healy, AKThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 4, 2018 · N57787 · Substantial damageNTSB ANC18LA042Accident · Minor injuriesLimited investigationFinal reportGippsaero PTY GA10 · Mojave, CAThe flight crew's inappropriate decision, without authorization or consultation from the manufacturer's chief design engineer, to introduce flaps in the landing configuration into the entry spin testing, which resulted in an unrecoverable spin and impact with…Jun 4, 2018 · VH-XMH · DestroyedNTSB CEN18LA209Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Longview, TXThe pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…Jun 1, 2018 · N72066 · Substantial damageNTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.Jun 1, 2018 · N9410M · Substantial damageNTSB CEN18LA211Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Parkin, ARThe improper operation of the rudder pedal adjustment mechanism for an undetermined period of time, which led to the failure of the rudder pedal adjustment track, the detachment of the rudder pedal, and the pilot’s subsequent inability to maintain directional…May 31, 2018 · N6215P · Substantial damageNTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.May 29, 2018 · N7546K · Substantial damageNTSB ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.May 29, 2018 · N86507 · Substantial damageNTSB CEN18LA200Accident · No injuriesClass 3 · LimitedFinal reportIrlbeck Thomas H RV 8 · Somerset, WIA total loss of engine power due to damaged and disconnected electronic ignition wires from both the main and backup batteries, which resulted in a forced landing.May 29, 2018 · N214FF · Substantial damageNTSB GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.May 28, 2018 · N2167D · Substantial damageNTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.May 27, 2018 · N95410 · Substantial damageNTSB CEN18LA195Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Katy, TXThe loss of airplane control on takeoff due to the absence of the attachment bolt for the left aileron actuation arm.May 27, 2018 · N67Y · Substantial damageNTSB ANC18LA038Accident · Minor injuriesLimited investigationFinal reportJames Wiebe Belite Pipper · Anchorage, AKAn inadequate fuel supply to the engine, which resulted in a total loss of engine power and subsequent impact with terrain.May 24, 2018 · N3748 · Substantial damageNTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.May 21, 2018 · N244TW · Substantial damageNTSB ERA18LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Sandersville, GAA nose landing gear collapse for reasons that could not be determined based on the available information.May 21, 2018 · N427JM · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damageNTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.May 19, 2018 · N833RD · Substantial damageNTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…May 17, 2018 · N7750F · Substantial damageNTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.May 16, 2018 · N4EJ · Substantial damageNTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.May 14, 2018 · N25WE · Substantial damageNTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 10, 2018 · N82XC · Substantial damageNTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.May 8, 2018 · N3291U · Substantial damageNTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.May 7, 2018 · N3292Y · Substantial damageNTSB CEN18LA157Accident · Minor injuriesLimited investigationFinal reportHartline J Bon Hartline Kitfox III · Marathon, TXThe failure of the flaperon hinge attachment point during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the lack of reinforcement of the hinge attachment point in accordance with the manufacturer’s service bulletin.May 2, 2018 · N73BH · Substantial damageNTSB CEN18LA164Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sioux Falls, SDFailure of the right main landing gear drag brace bolt for reasons that could not be determined based on the available information.Apr 30, 2018 · N172GA · Substantial damageNTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.Apr 27, 2018 · N54V · Substantial damageNTSB WPR18LA129Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 695A · Bishop, CAThe failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.Apr 26, 2018 · N79PH · Substantial damage