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 LAX05FA189Accident · Serious injuriesField investigationFinal reportRobinson R44 · Lucerne Valley, CAthe pilot's failure to maintain adequate main rotor rpm and directional control while maneuvering at low altitude. Contributing factors in the accident were the helicopter's gross weight in excess of the maximum hover out of ground effect limit, a high…NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB DFW05CA131Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Cherry Valley, ARThe pilot's failure to calculate take off-distance performance data, which resulted in insufficient runway length for take off. Factors were the tailwind and high gross weight.NTSB DEN05LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Provo, UTthe dual student’s failure to maintain adequate rotor rpm and the inadequate supervision by the instructor.NTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB LAX05CA185Accident · No injuriesData collectionFinal reportRobinson R44 · Sedona, AZthe pilot's improperly planned approach and misjudged distance/speed. A factor was the high density altitude.NTSB DFW05CA130Accident · Serious injuriesData collectionFinal reportCessna 182P · Lowell, ARThe instructor's inadequate supervision and the second pilot's inadequate planning/decision to assure adequate takeoff performance to clear obstacles. Contributing factors were the prevailing quartering tailwind, the pilots selection of the wrong runway, and…NTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.NTSB DEN05LA081Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · St. George, UTthe pilot's improper autorotation. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN05CA079Accident · No injuriesData collectionFinal reportSchweizer 269C · Pueblo, COthe student pilot's failure to maintain control of the helicopter during the landing. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.NTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB ATL05CA080Accident · No injuriesData collectionFinal reportPiper J4E · Akron, ALThe pilot's premature liftoff and his failure to attain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's delay in aborting the takeoff.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB DFW05CA120Accident · No injuriesData collectionFinal reportMayfield Sparrowhawk · Hondo, TXThe pilot's failure to maintain control of the gyrocraft during takeoff. A contributing factor was the failure of the pre-rotator cable.NTSB LAX05LA164Accident · No injuriesLimited investigationFinal reportRobinson R44 · Gustine, CAthe improper installation of the nut/bolt assembly connecting the left cyclic push-pull tube to the non-rotating swashplate by maintenance personnel, which led to a loss of roll control during takeoff.NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…NTSB DFW05CA121Accident · No injuriesData collectionFinal reportBell 206L-1 · Georgetown, TXThe pilot's improper flare resulting in a hard landing.NTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB DFW05CA109Accident · No injuriesData collectionFinal reportRobinson R22 · Bandera, TXThe pilot's loss of control while hovering after encountering settling with power.NTSB DFW05LA110Accident · Minor injuriesLimited investigationFinal reportFriddle Super Cub Replica · Springtown, TXThe pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.NTSB SEA05CA083Accident · No injuriesData collectionFinal reportHughes 269A · Whitefish, MTThe student pilot's failure to maintain control of the helicopter while hovering resulting in an in-flight collision with terrain. Gusting winds and the student pilot's inadequate compensation for the wind conditions were contributing factors.NTSB IAD05CA056Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA40 · Leesburg, VAThe pilot's failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the uphill terrain.NTSB IAD05LA055Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Oakland, MDThe pilot's delay in aborting the landing, which resulted in an inadvertent stall/mush into the trees. A factor in the accident was the tailwind.NTSB SEA05FA075Accident · 1 fatalField investigationFinal reportRaytheon Bonanza · South Bay, FLThe pilot's failure to maintain aircraft control while in cruise flight. Factors include night conditions and flat featureless terrain.NTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.NTSB IAD05LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Rocky Hill, NJThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall, and subsequent impact with terrain. Factors included the night lighting conditions, and the airplane approaching the opposite runway.NTSB DEN05FA066Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Broomfield, COthe pilot's failure to maintain aircraft control during landing. Contributing factor's included the quartering tailwind, and the pilot's inadequate in-flight decision making.NTSB LAX05LA131Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIthe pilot's failure to maintain an adequate airspeed while maneuvering during a scenic flight, which led to an inadvertent stall/spin and secondary stall/spin encounter. Contributing factors were the pilot's lack of total flight experience, his inadequate…NTSB MIA05FA085Accident · 2 fatalField investigationFinal reportCommander 114-B · Venice, FLThe pilot's in-flight loss of control during takeoff/initial climb over the water at night due to spatial disorientation. A related factor was the night conditions.NTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.NTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…NTSB IAD05FA047Accident · 6 fatalField investigationFinal reportPilatus PC-12/45 · Bellefonte, PAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an instrument final approach to land, which resulted in an inadvertent stall/spin. Factors associated with the accident are the inadvertent stall/spin, the pilot's failure to follow…NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB DFW05LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Tontitown, ARThe pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB NYC05CA062Accident · No injuriesData collectionFinal reportCessna 150L · Mitchellville, MDThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB LAX05FA114Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's failure to maintain adequate airspeed that resulted in an inadvertent stall/mush during initial climb. Contributing factors were the pilot's inadequate preflight preparations and the high density altitude.NTSB SEA05CA063Accident · No injuriesData collectionFinal reportJeffs J-Bird · St. Paul, ORThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain. A contributing factor was the pilot's decision to fly at low altitude.