NTSB investigations, 2006
249 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 332 |
|---|---|
| 1983 | 466 |
| 1984 | 438 |
| 1985 | 425 |
| 1986 | 370 |
| 1987 | 348 |
| 1988 | 369 |
| 1989 | 320 |
| 1990 | 359 |
| 1991 | 354 |
| 1992 | 332 |
| 1993 | 304 |
| 1994 | 323 |
| 1995 | 280 |
| 1996 | 263 |
| 1997 | 264 |
| 1998 | 281 |
| 1999 | 263 |
| 2000 | 274 |
| 2001 | 248 |
| 2002 | 245 |
| 2003 | 279 |
| 2004 | 237 |
| 2005 | 281 |
| 2006 | 249 |
| 2007 | 299 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2006
AND 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 year(c."eventDate") = 2006 AND 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 NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.NTSB LAX07LA067Accident · 1 fatalLimited investigationFinal reportCessna 150J · San Diego, CAThe pilot's improper use of the throttle and failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.NTSB DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.NTSB CHI07FA048Accident · 2 fatalField investigationFinal reportMooney M-20F · Mt. Gilead, OHBoth the pilot-in-command/aircraft owner and the flight instructor failed to recover from the stall and the flight instructor's inadequate supervision of the flight. Contributing to the accident was the failure to maintain stall speed which resulted in the…NTSB ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.NTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.NTSB CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…NTSB DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.NTSB MIA07CA027Accident · Serious injuriesData collectionFinal reportRichard F. Sheldon Aventura II · Palm Beach Gard, FLThe pilot's failure maintain the proper airspeed during takeoff, which resulted in a stall.NTSB NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB ANC07FA007Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot's failure to maintain control of the airplane during cruise flight, which resulted in an uncontrolled descent, and an in-flight collision with snow-covered terrain. Contributing to the accident were the pilot's spatial disorientation, and dark night…NTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.NTSB DFW07FA036Accident · 3 fatalField investigationFinal reportCessna 310Q · Waco, TXThe pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…NTSB LAX07LA055Accident · Serious injuriesLimited investigationFinal reportHigher Class Super Hornet · Chandler, AZA loss of aircraft control for undetermined reasons.NTSB ATL07LA025Accident · 2 fatalLimited investigationFinal reportFagan Rans S-6S · Taylorsville, NCThe pilots failure to maintain airspeed while maneuvering resulting in an inadvertent stall, uncontrolled decent, collision with the ground, and a post crash fire.NTSB CHI07LA035Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Atlanta, GAThe exceedance of airplane design stress limits when the pilot did not maintain aircraft control after his attention was diverted to the right side attitude indicator during cruise flight. An additional cause was the aural detection for the autopilot…NTSB NYC07FA038Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601P · West Dover, VTA loss of control during approach for undetermined reasons, which resulted in a collision with trees.NTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.NTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.NTSB LAX07TA051Accident · No injuriesFinal reportLearjet 36 · San Diego, CAThe pilot's failure to maintain aircraft control while maneuvering, which resulted in exceeding the design stress limits of the aircraft. Contributing to the accident was the sunglare.NTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.NTSB DFW07LA026Accident · 2 fatalLimited investigationFinal reportKeesler Pulsar · Alvarado, TXThe pilot's improper handling of the airplane while manuevering at a low altitude, which resulted in an inadvertant stall.NTSB NYC07CA035Accident · Minor injuriesData collectionFinal reportBaggett RV6A · Nokesville, VAThe pilot's inadequate compenstation for a crosswind while landing, which resulted in a loss of directional control.NTSB MIA07CA020Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Melbourne, FLThe pilot's (Dual Student) failure to relinquish control of the airplane when instructed by the certified flight instructor resulting in airspeed not being maintained and an inadvertent stall.NTSB ATL07CA023Accident · No injuriesData collectionFinal reportHudspeth Shawn D Challenger II · Bessemer, ALThe pilot's failure to maintain control of the airplane during an approach for landing. A factor in the accident was gusting winds.NTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…NTSB MIA07CA018Accident · Serious injuriesData collectionFinal reportSargent Jonathan Varieze · Punta Gorda, FLThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight, which did not ensure the security of the canopy before flight.NTSB NYC07FA029Accident · Serious injuriesField investigationFinal reportRobinson R44 II · Baltimore, MDThe pilot's failure to maintain control while landing to a trailer, which resulted in a collision with terrain. A factor in the accident was the narrow trailer.NTSB CHI07FA022Accident · 5 fatalField investigationFinal reportCessna T303 · Mill Creek, INThe pilot became spatially disoriented and as a result failed to maintain control of the airplane. Factors associated with the accident were the instrument meteorological conditions aloft and the pilot being fatigued.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB ATL07CA017Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Raleigh, NCThe pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.NTSB DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB NYC07CA014Accident · No injuriesData collectionFinal reportCessna 172N · Morgantown, WVThe student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.NTSB LAX07LA023Accident · 1 fatalLimited investigationFinal reportMoyes Dragonfly · Brentwood, CAthe pilot's failure to obtain and maintain an adequate airspeed during the initial climb resulting in a stall and uncontrolled descent into terrain.NTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…NTSB DEN07IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COThe inadvertent activation of the priority pushbutton on the sidestick by the first officer resulting in a nose down pitch and loss of aircraft control during the landing flare.NTSB DEN07CA015Accident · No injuriesData collectionFinal reportCessna T210G · Delta, COthe pilot's failure to maintain aircraft control and a proper descent rate during the landing.NTSB SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.NTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…NTSB DFW07FA008Accident · 1 fatalField investigationFinal reportNorth American T-28C · Georgetown, LAThe pilot's failure to maintain control of the airplane which led to an aerodynamic stall. A contributing factor was the dark night.NTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.NTSB MIA07CA007Accident · Minor injuriesData collectionFinal reportCessna 150L · Umatilla, FLThe flight instructor's delayed remedial action during a go-around, which resulted in a failure to maintain sufficient airspeed to avoid a stall/mush, and an in-flight collision with terrain.NTSB NYC07CA010Accident · No injuriesData collectionFinal reportCirrus SR-22 · Lumberton, NJThe pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.NTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.NTSB DEN07CA009Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Hope, NMthe pilot's failure to maintain aircraft control. Contributing factors in this accident included the sudden wind shift and high density altitude, resulting in the helicopter settling with power, and the high vegetation.NTSB ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.