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 WPR13LA382Accident · No injuriesLimited investigationFinal reportCessna 206 · Boise, IDThe mechanical failure of the nose landing gear for reasons that could not be determined because impact damage prevented a complete examination.NTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB ERA13LA365Accident · No injuriesLimited investigationFinal reportFetterman Lanny R Firestar II · Numidia, PAA fatigue failure of the right main landing gear wheel axle attachment bracket, which resulted in a nose-over during a precautionary landing.NTSB CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.NTSB ANC13CA080Accident · Minor injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection.NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB CEN13LA490Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Eastport, MIA fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB WPR13CA369Accident · No injuriesData collectionFinal reportCessna 172RG · Kent, WAFailure of the certified flight instructor and student pilot to complete the landing checklist resulting in a gear-up landing.NTSB ANC13CA075Accident · No injuriesData collectionFinal reportCessna 185D · North Pole, AKThe malfunction of the right main wheel brake during taxi due to a faulty O-ring in the right brake pedal master cylinder.NTSB ERA13LA363Accident · No injuriesLimited investigationFinal reportMooney M20R · Tallahassee, FLThe pilot's failure to troubleshoot the in-flight electrical problem and restore power using the operable redundant battery and his decision not to manually extend the airplane's landing gear, which resulted in a gear-up landing. Contributing to the accident…NTSB ERA13CA352Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Erwinna, PAThe student pilot's improper altitude and energy management in the landing pattern which resulted in the glider impacting a tree and landing short of the runway.NTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.NTSB WPR13LA347Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Red Bluff, CAThe pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.NTSB ERA13CA338Accident · No injuriesData collectionFinal reportCessna 210M · Shirley, NYThe pilot's loss of control during an aborted takeoff as a result of his failure to properly configure the elevator trim prior to flight.NTSB CEN13FA440Accident · No injuriesField investigationFinal reportPhelps Kitfox III · Oshkosh, WIThe degraded fuel line, which prevented fuel from the left tank from reaching the header tank and resulted in the loss of engine power due to fuel starvation.NTSB WPR13GA338Accident · 1 fatalFinal reportBell HH-1H · Mount Charleston, NVThe premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.NTSB ANC13LA089Accident · No injuriesLimited investigationFinal reportHoward M. Shepherd Supercub · Hoonah, AKThe pilot’s selection of an unsuitable off-airport landing site and his subsequent landing at too high of an airspeed, which resulted in his excessive use of brakes during the landing roll and resulted in a nose-over.NTSB ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC13LA065Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKThe pilot’s loss of airplane control during landing for reasons that could not be determined based on the available evidence.NTSB CEN13LA408Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot’s failure to use the proper taxi procedure, which resulted in a brake system fire.NTSB ERA13LA318Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaufort, NCA failure of the right brake for reasons that could not be determined because a postaccident examination of the brake could not be performed.NTSB WPR13LA322Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Albany, ORThe loss of hydraulic fluid, which rendered the brakes ineffective. The reason for the loss of hydraulic fluid could not be determined based on the available evidence.NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB WPR13CA316Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Casa Grande, AZThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's and the flight examiner's distracted attention.NTSB WPR13LA319Accident · No injuriesLimited investigationFinal reportCessna T210K · Phoenix, AZThe collapse of the left main landing gear due to a broken gear tooth in the landing gear actuator.NTSB ANC13LA063Accident · No injuriesLimited investigationFinal reportCurtiss Wright C-46F · Fairbanks, AKThe failure of the right main landing gear side brace due to fatigue, which resulted in a collapse of the right main landing gear.NTSB WPR13CA306Accident · No injuriesData collectionFinal reportMaule MX7-180A · Elko, NVA flat main landing gear tire during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA383Accident · Serious injuriesLimited investigationFinal reportVink Robert D Youngster · Grand Haven, MIThe loss of engine power due to carburetor icing.NTSB WPR13FA300Accident · 2 fatalField investigationFinal reportAllstar PZL Glider SZD-54-2 Perkoz · Jacumba, CAThe premature release of the towline from the glider and the glider’s subsequent right banking turn at low altitude for reasons that could not be determined because postaccident airframe examination did not reveal any evidence of a mechanical malfunction or…NTSB ERA13LA312Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Jackson, TNA failure of the right main landing gear wheel rim during the landing roll, resulting in a loss of control and a subsequent collapse of the right main landing gear.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.NTSB CEN13LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Eagle, COThe pilots’ improper fuel management, which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was worn and corroded fuel senders, which transmitted inaccurate fuel readings to the fuel monitoring system.NTSB WPR13FA294Accident · 1 fatalField investigationFinal reportCessna 172 · Birdseye, UT***This report was modified on August 18, 2015. Please see the docket for this accident to view the original report.*** The operator's improper installation of a supplemental electrical power supply, which caused a short circuit due to inadequate vibration…NTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.NTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.NTSB ERA13IA294Incident · No injuriesIncident investigationFinal reportIai GULFSTREAM200 · Jamestown, NYThe pilots’ failure to effectively use the airplane's primary (brakes), secondary (thrust reversers), and emergency braking systems to decelerate the airplane, which resulted in a runway excursion. Contributing to the accident was the pilots’ failure to…NTSB CEN13LA365Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Lansing, MIThe pilot’s failure to follow the airplane checklist, which resulted in the parking brake not being released before taxi and a subsequent brake fire.NTSB CEN13LA366Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Cincinnati, OHLoss of control due to insufficient airspeed on takeoff and premature landing gear retraction, which resulted in the collapse of the left landing gear as the airplane impacted the runway.NTSB WPR13LA274Accident · No injuriesLimited investigationFinal reportCessna T210L · Fresno, CAA hydraulic fluid leak in the nose landing gear actuator rod seal, which prevented the hydraulic system from building up sufficient pressure to fully retract or extend the main landing gear.NTSB WPR13LA272Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Needles, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning. Contributing to the severity of the front passenger’s injuries was the pilot’s decision to depart with more passengers than available seats, which resulted in…NTSB ERA13LA288Accident · Serious injuriesLimited investigationFinal reportHagerty RV-7A · Altoona, PAThe pilot's improper recovery from an encounter with a wind gust during landing, which resulted in a hard landing on, and displacement of, the nose landing gear and a subsequent runway excursion and noseover.NTSB CEN13FA351Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · La Pointe, WIThe pilot’s failure to maintain airplane control after deciding to go around after a gear-up landing, resulting in an aerodynamic stall.NTSB ERA13LA285Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Oxford, NCThe failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation.NTSB ERA13CA286Accident · No injuriesData collectionFinal reportLuscombe 8A · Orangeburg, SCThe inadvertent slippage of the pilot's foot off the right rudder pedal, resulting in a loss of directional control on the ground, and the pilot's overly aggressive application of wheel brakes, resulting in a nose over.NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.