NTSB investigations, 2006

203 cases where the phase of flight was Maneuvering.

Cases per year

19622026
NTSB investigations, 2006 per year, 1962–2026: 18,849 cases
1964415
1965419
1966366
1967410
1968394
1969360
1970330
1971384
1972359
1973407
1974410
1975407
1976480
1977443
1978433
1979384
1980377
1981374
1982416
1983476
1984462
1985402
1986357
1987357
1988349
1989313
1990307
1991350
1992309
1993315
1994322
1995320
1996279
1997262
1998259
1999267
2000281
2001257
2002241
2003263
2004224
2005212
2006203
2007222
2008234
2009208
2010222
2011250
2012236
2013216
2014199
2015217
2016177
2017201
2018187
2019197
2020165
2021186
2022186
2023191
2024165
2025145
202690

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 450)
  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 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.Dec 31, 2006 · N50814 · Substantial damageNTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.Dec 30, 2006 · N93TT · Substantial damageNTSB DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.Dec 30, 2006 · N9655F · Substantial damageNTSB 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…Dec 27, 2006 · N9596M · Substantial damageNTSB LAX07CA063Accident · No injuriesData collectionFinal reportBelcher Helicycle · Boulder City, NVa loss of engine power due to a fractured fuel line.Dec 23, 2006 · N6912B · Substantial damageNTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.Dec 21, 2006 · N9141Y · Substantial damageNTSB 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.Dec 10, 2006 · N949S · DestroyedNTSB LAX07LA054Accident · 2 fatalLimited investigationFinal reportJohn Lauer Harmon Rocket II · Bakersfield, CAThe pilot's failure to maintain terrain clearance during an aerobatic maneuver.Dec 9, 2006 · N604JL · DestroyedNTSB LAX07CA053Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mojave, CAthe pilot's failure to maintain adequate clearance from a sign while performing a low altitude maneuver.Dec 7, 2006 · N9525C · Substantial damageNTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.Dec 3, 2006 · N914C · DestroyedNTSB CHI07FA032Accident · 2 fatalField investigationFinal reportCessna 172 · Crookston, MNThe pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.Dec 2, 2006 · N9850G · DestroyedNTSB 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.Dec 1, 2006 · N26FN · Substantial damageNTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.Nov 25, 2006 · N4426X · Substantial damageNTSB LAX07LA045Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Queen Creek, AZThe total loss of engine power resulting from the failure of the engine's air compressor due to a seized piston, which resulted in the stoppage of the oil pump, fuel pump, and tachometer generator, in addition to the compressor. The underlying reason for the…Nov 23, 2006 · N8181C · Substantial damageNTSB 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.Nov 23, 2006 · N115SE · DestroyedNTSB SEA07LA022Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Lyons, ORA severing of the helicopter's cyclic and collective rods by one of the load lifting slings following the failure of the other sling. A contributing factor was the hard landing due to the fact that an autorotation was not possible.Nov 22, 2006 · N1611W · Substantial damageNTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.Nov 21, 2006 · N500FU · Substantial damageNTSB MIA07CA021Accident · Minor injuriesData collectionFinal reportRobinson R22 · Lakeland, FLThe flight instructor's failure to maintain control of the helicopter during takeoff resulting in a roll over.Nov 21, 2006 · N2302A · Substantial damageNTSB NYC07LA030Accident · No injuriesLimited investigationFinal reportStump Rotorway Exec 90 · Manchester, NHAn improperly installed oil line, which resulted in oil line fatigue failure and a subsequent loss of oil to the engine. A contributing factor was the sloping terrain at the forced landing site.Nov 18, 2006 · N169JS · Substantial damageNTSB 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.Nov 15, 2006 · N74548 · Substantial damageNTSB NYC07FA025Accident · 1 fatalField investigationFinal reportCzech Aircraft Works CH 601 XL RTF · Basye, VAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Nov 11, 2006 · N601VA · Substantial damageNTSB 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.Nov 6, 2006 · N1541T · DestroyedNTSB 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.Nov 5, 2006 · N107TM · Substantial damageNTSB LAX07TA029Accident · No injuriesFinal reportEurocopter France AS350B3 · Apple Valley, CAthe pilot's improper use of the collective control during a practice hover autorotation, which resulted in a hard landing. A factor in the accident was the certificated flight instructor's inadequate supervision of the maneuver.Nov 5, 2006 · N109HP · Substantial damageNTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.Nov 2, 2006 · N606RV · Substantial damageNTSB LAX07LA027Accident · 2 fatalLimited investigationFinal reportAir Creations Tanarg 912 · Bisbee, AZThe pilot's failure to maintain clearance from the mountainous terrain.Nov 1, 2006 · UNREG · DestroyedNTSB 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…Oct 27, 2006 · N969ES · Substantial damageNTSB 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.Oct 22, 2006 · N470 · DestroyedNTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…Oct 18, 2006 · N121CS · DestroyedNTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.Oct 18, 2006 · N401MS · Substantial damageNTSB NYC07LA008Accident · 1 fatalLimited investigationFinal reportFlynn William Pazmany PL-4 · Fredricksburg, VAThe pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.Oct 15, 2006 · N640F · Substantial damageNTSB 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.Oct 15, 2006 · N75262 · Substantial damageNTSB NYC07FA007Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau Gmbh 300 · Culpeper, VAThe pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.Oct 14, 2006 · N168EX · DestroyedNTSB MIA07CA004Accident · No injuriesData collectionFinal reportHughes OH-6A · Key Largo, FLThe pilot's inadvertent encounter with a loss of tail rotor effectiveness during hover in a crosswind wind.Oct 11, 2006 · N810SB · Substantial damageNTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.Oct 11, 2006 · N929CD · DestroyedNTSB NYC07FA003Accident · 2 fatalField investigationFinal reportMooney M20F · Brownsville, PAA loss of aircraft control, for unknown reasons, while maneuvering.Oct 9, 2006 · N3447N · Substantial damageNTSB DEN07FA003Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Tucumcari, NMThe pilot's failure to maintain aircraft control during aerobatic flight, resulting in an inadvertent accelerated stall. Contributing factors include the low altitude for recovery from the loop and the high density altitude.Oct 4, 2006 · N300BB · Substantial damageNTSB ATL07LA001Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Somerville, TNThe total loss of engine power for undetermined reasons.Oct 4, 2006 · N493Y · DestroyedNTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.Oct 1, 2006 · N189AC · Substantial damageNTSB ATL06LA133Accident · No injuriesLimited investigationFinal reportRobinson R44 · Beaufort, NCThe loss of engine power for undetermined reasons.Sep 30, 2006 · N140JM · Substantial damageNTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.Sep 28, 2006 · N565CH · DestroyedNTSB LAX06FA304Accident · 2 fatalField investigationFinal reportCessna 182K · Sedona, AZThe pilot's failure to maintain clearance from trees and terrain while maneuvering in mountainous/hilly terrain in a high density altitude environment.Sep 24, 2006 · N2700Q · DestroyedNTSB DFW06CA213Accident · No injuriesData collectionFinal reportRobinson R22 · Skiatook, OKThe pilot's failure to maintain control of the helicopter following an encounter with dynamic rollover.Sep 24, 2006 · N468SH · Substantial damageNTSB ANC06FA136Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering to reverse direction, which resulted in an inadvertent stall and an uncontrolled descent. Factors associated with the accident were the inadvertent stall and wind gusts.Sep 21, 2006 · N5154G · Substantial damageNTSB NYC06LA227Accident · 2 fatalLimited investigationFinal reportAir Trikes Tourist · Middlebury, VTA loss of control for undetermined reasons.Sep 20, 2006 · UNREG · DestroyedNTSB ANC06CA133Accident · No injuriesData collectionFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain while maneuvering at a low altitude, which resulted in an in-flight collision with terrain. Factors associated with the accident were a downdraft, the pilot's intentional low…Sep 18, 2006 · N82905 · Substantial damageNTSB DEN06GA128Accident · 2 fatalFinal reportPiper PA-23-250 · Fort Meade, FLA loss of power in the right engine while manuevering for reasons undetermined, and failure to maintain aircraft control which resulted in an inadvertent stall. Contributing factors were the airspeed below Vmc, and an altitude too low to afford a safe…Sep 14, 2006 · N5941Y · DestroyedNTSB LAX06LA292Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Minden, NVThe inadequate pre-takeoff checks by the flightcrew that failed to detect that the spoilers were deployed during the takeoff and initial climb. Also causal was the inadequate supervision of the flight by the flight instructor.Sep 12, 2006 · N790G · Substantial damageNTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.Sep 8, 2006 · N3082P · DestroyedNTSB LAX06GA287Accident · 2 fatalFinal reportNorth American OV-10A · Porterville, CAthe pilot's failure to maintain adequate terrain clearance while maneuvering over rising terrain in a box canyon. Also causal was the pilot's failure to adhere to procedures/directives regarding minimum altitude requirements.Sep 6, 2006 · N419DF · Destroyed