NTSB investigations
8,203 cases where the first occurrence was “Loss of control - in flight”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 CHI99FA023Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rock, KSthe pilot failed to maintain control of the aircraft and made an improper evaluation of the weather. Additional factors were flying a test flight at night with the icing conditions in the clouds.NTSB LAX99LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Mammoth, CAThe pilot's failure to ensure that the autopilot was off prior to takeoff, and, his failure to maintain pitch control during the resultant pitch trim excursion during the takeoff ground roll.NTSB LAX99LA022Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Pioche, NVThe loss of tail rotor effectiveness, due to the installation of incorrect pitch links by the maintenance facility. A factor in the accident was the lack of an adequate quality assurance program in the maintenance facility.NTSB IAD99LA012Accident · No injuriesLimited investigationFinal reportPitcairn RAF 2000 · Doylestown, PAThe pilot's inadequate compensation for wind conditions and his inadequate recovery from a bounced landing. Contributing to the accident were the pilot's fatigue and the crosswind conditions.NTSB CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.NTSB MIA99LA022Accident · 1 fatalLimited investigationFinal reportFerguson Rans S-10 Sakota · Pisgah, MSThe pilot's failure to maintain aircraft control during a low altitude maneuver resulting in the aircraft's uncontrollable descent until impact with the terrain.NTSB CHI99LA019Accident · No injuriesLimited investigationFinal reportCessna 310R · Wichita, KSthe pilot's inadequate compensation for the wind conditions and the inadequate recovery from the bounced landing which resulted in a loss of control and the ground loop. Factors associated with the accident were the pilot's misjudging the winds conditions and…NTSB CHI99LA021Accident · Minor injuriesLimited investigationFinal reportJordan Acey Deucy P70 · Ava, MOthe pilot's attempted operation of the airplane with known deficiencies, and his not obtaining control of the airplane in flight. A factor was asymmetrical ailerons.NTSB LAX99FA020Accident · 3 fatalField investigationFinal reportCessna 182Q · Nixon, NVThe noninstrument rated pilot's failure to maintain control of the airplane during an attempted flight into adverse weather which resulted in inadvertent VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's failure to…NTSB CHI99LA013Accident · 1 fatalLimited investigationFinal reportC.B. Withun T-BIRD II · New Haven, MIthe improper installation of the propeller by the owner/pilot- mechanic and the pilot not maintaining the airplane's airspeed while approaching the trees along the airplane's flight path. A factor in this accident was the stall encountered by the pilot.NTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.NTSB CHI99LA010Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Duluth, MNThe inadequate airspeed by the pilot-in-command. Contributing factors were the gusts and the trees.NTSB IAD99LA011Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · East Moriches, NYThe student pilot's failure to maintain adequate airspeed and the certified flight instructor's inadequate supervision.NTSB NYC99LA011Accident · No injuriesLimited investigationFinal reportZeidler Sonerai II · Kenton, OHThe pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…NTSB MIA99LA008Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Rossville, TNThe failure of the pilot to maintain airspeed (VSO) while maneuvering in a recovery from a spin.NTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB SEA99LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Buhl, IDThe pilot's failure to follow the aircraft's recommended balked landing procedure, resulting in a stall. Factors include the pilot's failure to maintain directional control during the landing flare, the pilot's lack of total experience, and insufficient…NTSB CHI99LA005Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Holstein, WIthe pilot-in-command's intentional low altitude maneuver and his ostentatious display. A factor was his allowing the airplane to enter an inadvertent stall.NTSB IAD99LA007Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW99LA007Accident · 1 fatalLimited investigationFinal reportPainton Loehle Aviation 5151 · Osceola, ARThe pilot's failure to maintain aircraft control due to incapacitation as a result of hypertensive arteriosclerotic cardiovascular disease.NTSB CHI99LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Oshkosh, NEthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the high winds, low altitude at which the pilot was maneuvering and the uneven terrain which the helicopter contacted.NTSB ATL99LA007Accident · 2 fatalLimited investigationFinal reportW.S. Bowers, Jr. RV-4 · Apopka, FLThe pilot's failure to maintain airspeed while performing aerobatics which resulted in the lost of control and a stall/spin. A contributing factor was the low altitude at which the maneuver was performed.NTSB CHI99FA003Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Howell, MIThe pilot's failure to maintain/exceed the Vmc airspeed during a go-around maneuver. Contributing factors were the shutting down of the left engine and the lack of recent experience in the type operation.NTSB IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.NTSB DEN99FA004Accident · 1 fatalField investigationFinal reportCameron A-250 · Albuquerque, NMThe pilot not planning his approach to a landing so as to fly over the transmission wires (on the approach edge of the landing field) in level flight or ascending flight, and the pilot not pulling out the rip panel for emanate contact with transmission wires…NTSB LAX99LA004Accident · 1 fatalLimited investigationFinal reportBurson Revolution Mini 500 · Moorpark, CAThe improper use of the cyclic flight control by the pilot, which resulted in low g flight load condition, which resulted in rotor disk divergence (mast bumping), and the main rotor blade striking and severing the tail boom.NTSB DEN99LA002Accident · No injuriesLimited investigationFinal reportBell 206B · Vernal, UTLoss of tail rotor effectiveness. A factor was the quartering tailwind.NTSB ATL99LA003Accident · No injuriesLimited investigationFinal reportAuxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FLThe pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.NTSB LAX98LA311Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Salinas, CAThe failure of the student pilot to maintain control of the aircraft while practicing autorotations.NTSB SEA98LA189Accident · No injuriesLimited investigationFinal reportCessna 172D · Ronan, MTThe pilot's failure to attain adequate airspeed during liftoff from a soft field takeoff. Factors include high density alttiude.NTSB CHI98LA364Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Marshall, MIthe pilot-in-command (CFI)'s inadequate supervision of the student, his not obtaining control of the airplane, and his lack of total experience in the type of operation. A factor was the dual student's not maintaining control of the airplane.NTSB ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.NTSB FTW98LA413Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Belen, NMThe pilot inadvertently stalling the airplane.NTSB LAX98LA309Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Gilroy, CAThe pilot's loss of control for undetermined reasons.NTSB FTW98LA419Accident · No injuriesLimited investigationFinal reportHundere Kitfox II · Somerset, TXThe pilot's inadvertent stall. Factors were the wind sock that was displaying inaccurate information, the gusty wind condition, and the pilot's lack of experience in the tailwheel equipped airplane.NTSB FTW98LA409Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Catoosa, OKThe pilot's failure to maintain control of the airplane resulting in an inadvertent stall.NTSB CHI98LA361Accident · 2 fatalLimited investigationFinal reportChampion BL-7-GCBC · Upham, NDThe pilot's steep pull and failure to maintain adequate airspeed, which resulted in a stall/spin. Contributing factors were the pilot's lack of familiarity with the airplane's handling qualities, and a lack of recent experience in the airplane.NTSB FTW98LA402Accident · No injuriesLimited investigationFinal reportFairchild M-62A-3 · Amarillo, TXThe inadvertent stall due to the pilot's failure to maintain proper airspeed during the takeoff.NTSB LAX98FA297Accident · 2 fatalField investigationFinal reportBeech 35-B33 · San Jose, CAthe pilot's loss of aircraft control and entry into a spiral dive for undetermined reasons. The dark night lighting conditions and the pilot's probable low recent flight experience were factors in this accident.NTSB FTW98LA405Accident · Minor injuriesLimited investigationFinal reportBell UH-1L · Price, UTThe pilot's inadvertent loss of tail rotor effectiveness. Factors were the high density altitude flight conditions, the unfavorable wind condition, and the none suitable terrain for an autorotation.NTSB LAX98LA314Accident · No injuriesLimited investigationFinal reportMooney M20C · Reno, NVThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a hard landing.NTSB LAX98LA295Accident · 1 fatalLimited investigationFinal reportHughes Cassutt 111M2 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while maneuvering in gusty wind conditions, which led to an inadvertent stall/spin at low altitude.NTSB SEA98FA179Accident · 2 fatalField investigationFinal reportCessna 172M · Concrete, WAThe pilot's failure to maintain aircraft control for undetermined reasons. Night conditions were a factor.NTSB LAX98LA293Accident · Serious injuriesLimited investigationFinal reportPZL-Bielsko SZD-59 · Truckee, CAThe failure of the pilot to maintain sufficient airspeed which resulted in a inadvertent stall/spin.NTSB FTW98FA399Accident · 1 fatalField investigationFinal reportCessna 172N · Montezuma Crk, UTThe pilot's attempted aerobatic maneuver and the subsequent inadvertent stall/spin. A factor was his intentional low altitude flight.NTSB FTW98LA395Accident · Serious injuriesLimited investigationFinal reportMaule M-5-235C · Mimbres, NMThe pilot's failure to maintain aircraft control while maneuvering. Factors were a low altitude turn into a crosswind and a high density altitude.NTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.NTSB FTW98LA397Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tahlequah, OKThe pilot's failure to maintain directional control of the aircraft during takeoff. A factor was the gusty wind conditions at the time of the accident.NTSB MIA98LA245Accident · Serious injuriesLimited investigationFinal reportWood Glasair SH2 · Holly Hill, SCThe pilot's failure to maintain airspeed, and his failure to perform a go-around. The pilot's misjudgment of speed and distance during the landing is a contributing factor.NTSB LAX98LA289Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Tucson, AZFailure of the pilot to properly connect the aileron controls during reassembly of the glider, and, his inadequate preflight inspection of the glider.