# NTSB investigations, 2012: Maneuvering

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 5 · 236 cases

## Latest cases

- [NTSB WPR13FA073](https://openairdocs.org/ntsb/WPR13FA073.md): Beech B100 · Libby, MT · Accident · 2 fatal · Field investigation · Final report · Dec 19, 2012 · N499SW · Destroyed
  > The noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…
- [NTSB WPR13LA069](https://openairdocs.org/ntsb/WPR13LA069.md): Powerchute Airwolf 912ULS · Dell, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2012 · N480QP · Substantial damage
  > The pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.
- [NTSB ERA13LA087](https://openairdocs.org/ntsb/ERA13LA087.md): Rotorway DB-1 · Mayland, TN · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 2012 · N828X · Substantial damage
  > The pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.
- [NTSB CEN13FA100](https://openairdocs.org/ntsb/CEN13FA100.md): Aerovodochody L-29 Delfin · Combine, TX · Accident · 2 fatal · Field investigation · Final report · Dec 13, 2012 · N29NR · Substantial damage
  > The airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.
- [NTSB CEN13FA089](https://openairdocs.org/ntsb/CEN13FA089.md): Beech 58 · Manhattan, IL · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2012 · N4016A · Substantial damage
  > An in-flight loss of control and impact with terrain for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13LA062](https://openairdocs.org/ntsb/WPR13LA062.md): Cessna 172S · Kahului, HI · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N3554Y · Substantial damage
  > The noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.
- [NTSB CEN13FA085](https://openairdocs.org/ntsb/CEN13FA085.md): Piper PA 46-350P · Greensburg, IN · Accident · 4 fatal · Field investigation · Final report · Dec 2, 2012 · N92315 · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.
- [NTSB CEN13FA082](https://openairdocs.org/ntsb/CEN13FA082.md): Beech P35 · Correctionville, IA · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2012 · N1566Z · Substantial damage
  > The pilot’s failure to perform a go-around after encountering thick fog at night.
- [NTSB CEN13LA086](https://openairdocs.org/ntsb/CEN13LA086.md): Bell 47G-2 · Walkerville, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 1, 2012 · N3755Z · Substantial damage
  > The pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.
- [NTSB CEN13CA079](https://openairdocs.org/ntsb/CEN13CA079.md): Schweizer SGS 2-32 · Boulder, CO · Accident · Minor injuries · Data collection · Final report · Nov 29, 2012 · N9929J · Substantial damage
  > The glider pilot's inability to locate an area of thermal lift.
- [NTSB WPR13CA057](https://openairdocs.org/ntsb/WPR13CA057.md): Hughes 369D · Sheridan, OR · Accident · Minor injuries · Data collection · Final report · Nov 27, 2012 · N163PJ · Substantial damage
  > The pilot’s failure to prevent the helicopter from entering a vortex ring state (settling with power) condition during an external load operation, which resulted in the helicopter’s main rotor blades impacting the truck.
- [NTSB WPR13FA056](https://openairdocs.org/ntsb/WPR13FA056.md): Mcdaniel RV-6-CH · Scio, OR · Accident · 2 fatal · Field investigation · Final report · Nov 26, 2012 · N424D · Substantial damage
  > The pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.
- [NTSB WPR13LA050](https://openairdocs.org/ntsb/WPR13LA050.md): Sater Coot A-Amphib · San Andreas, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 23, 2012 · N8VS · Substantial damage
  > The pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.
- [NTSB ERA13WA066](https://openairdocs.org/ntsb/ERA13WA066.md): Aerospatiale AS-355F1 · Great Guana Cay, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · C6-APV · Substantial damage
  > On November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…
- [NTSB CEN13FA060](https://openairdocs.org/ntsb/CEN13FA060.md): Grumman American Avn. AA-1B · Burlington, WI · Accident · 2 fatal · Field investigation · Final report · Nov 18, 2012 · N6273L · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.
- [NTSB WPR13GA044](https://openairdocs.org/ntsb/WPR13GA044.md): Bell OH-58 · Altadena, CA · Accident · Minor injuries · Final report · Nov 17, 2012 · N911FA · 2 aircraft · Substantial damage
  > The landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…
- [NTSB ERA13WA431](https://openairdocs.org/ntsb/ERA13WA431.md): Beech 95B55 - B · Concepcion, Paraguay · Accident · 3 fatal · Foreign investigation · Nov 16, 2012 · ZP-BLV · Destroyed
  > On November 16, 2012, about 0813 local time (1113 coordinated universal time), a Beech BE-55, Paraguayan registration ZP-BLV, was destroyed when it impacted terrain about 500 meters short of the runway at a ranch in Departamento Presidente Hayes, about 50…
- [NTSB ERA13LA057](https://openairdocs.org/ntsb/ERA13LA057.md): Hughes 369D · Corning, NY · Accident · 2 fatal · Limited investigation · Final report · Nov 15, 2012 · N369AW · Substantial damage
  > The pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.
- [NTSB WPR13FA036](https://openairdocs.org/ntsb/WPR13FA036.md): North Wing Scout X-C · Waterville, WA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2012 · N467XW · Substantial damage
  > The pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.
- [NTSB WPR13LA035](https://openairdocs.org/ntsb/WPR13LA035.md): Cessna 172M · Modesto, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2012 · N21391 · Substantial damage
  > Failure of the throttle control cable during maneuvering flight, which resulted in a partial loss of engine power.
- [NTSB CEN13FA051](https://openairdocs.org/ntsb/CEN13FA051.md): Piper PA-28-140 · Anadarko, OK · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2012 · N7337J · Substantial damage
  > The pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.
- [NTSB ERA13GA046](https://openairdocs.org/ntsb/ERA13GA046.md): Hughes OH-6A · Atlanta, GA · Accident · 2 fatal · Final report · Nov 4, 2012 · N368PD · Substantial damage
  > The pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.
- [NTSB CEN13LA034](https://openairdocs.org/ntsb/CEN13LA034.md): US Light Hornet · Mont Belvieu, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 28, 2012 · N2482J · Substantial damage
  > The pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.
- [NTSB WPR13LA025](https://openairdocs.org/ntsb/WPR13LA025.md): Robinson Helicopter R22 Mariner · Lake Havasu, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2012 · N2627M · Substantial damage
  > The pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.
- [NTSB WPR13LA023](https://openairdocs.org/ntsb/WPR13LA023.md): Robinson Helicopter R-44 II · Toutle, WA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2012 · N7530F · Substantial damage
  > The pilot’s failure to maintain precise altitude control, which resulted in the helicopter entering a settling with power condition while hovering out of ground effect.
- [NTSB WPR13FA022](https://openairdocs.org/ntsb/WPR13FA022.md): Behne Glasair III · Byron, CA · Accident · 2 fatal · Field investigation · Final report · Oct 23, 2012 · N655DB · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.
- [NTSB ERA13FA032](https://openairdocs.org/ntsb/ERA13FA032.md): Swift Museum Foundation GC-1A · East Moriches, NY · Accident · 2 fatal · Field investigation · Final report · Oct 20, 2012 · N80823 · Substantial damage
  > The failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…
- [NTSB ERA13LA029](https://openairdocs.org/ntsb/ERA13LA029.md): Grumman Acft ENG Cor-Schweizer G-164B · Edison, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2012 · N6670K · Substantial damage
  > The total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.
- [NTSB WPR13FA017](https://openairdocs.org/ntsb/WPR13FA017.md): Cessna 182P · Yucca, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2012 · N20939 · Substantial damage
  > The pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13CA019](https://openairdocs.org/ntsb/CEN13CA019.md): Air Tractor AT-502B · Portales, NM · Accident · No injuries · Data collection · Final report · Oct 17, 2012 · N598LA · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during an aerial application flight.
- [NTSB ERA13TA021](https://openairdocs.org/ntsb/ERA13TA021.md): Bell OH-58A · Jackson, TN · Accident · Minor injuries · Final report · Oct 13, 2012 · N40TN · Substantial damage
  > A loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA022](https://openairdocs.org/ntsb/ERA13LA022.md): Hughes/Helicopter Assocs 369A · West Chester, PA · Accident · No injuries · Limited investigation · Final report · Oct 13, 2012 · N546 · 2 aircraft · Substantial damage
  > The pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…
- [NTSB ANC13FA001](https://openairdocs.org/ntsb/ANC13FA001.md): Grumman G-44 · Aleknagik, AK · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2012 · N139F · Substantial damage
  > The pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.
- [NTSB WPR13LA007](https://openairdocs.org/ntsb/WPR13LA007.md): Schleicher ASH25M · Kamuela, HI · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 2012 · N513WK · Substantial damage
  > The pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.
- [NTSB ERA13WA156](https://openairdocs.org/ntsb/ERA13WA156.md): Cessna 172S · Izmir, Türkiye · Accident · 1 fatal · Foreign investigation · Oct 6, 2012 · TC-CBI · Substantial damage
  > On October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…
- [NTSB CEN13FA006](https://openairdocs.org/ntsb/CEN13FA006.md): Beech A36 · Mabank, TX · Accident · 4 fatal · Field investigation · Final report · Oct 6, 2012 · N32GP · Destroyed
  > The pilot's loss of airplane control while maneuvering in instrument meteorological conditions.
- [NTSB WPR13LA004](https://openairdocs.org/ntsb/WPR13LA004.md): Piper PA-28-161 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Oct 5, 2012 · N8115Q · 2 aircraft · Substantial damage
  > The failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.
- [NTSB WPR13WA014](https://openairdocs.org/ntsb/WPR13WA014.md): Robinson R22 · Halls Creek, Australia, Australia · Accident · 1 fatal · Foreign investigation · Oct 3, 2012 · VH-LLF · Substantial damage
  > On October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…
- [NTSB WPR13LA003](https://openairdocs.org/ntsb/WPR13LA003.md): Robinson Helicopter R22 Beta · Rockport, WA · Accident · No injuries · Limited investigation · Final report · Oct 3, 2012 · N80140 · Substantial damage
  > The pilot's failure to maintain sufficient rotor rpm during a precautionary landing, which resulted in a hard landing.
- [NTSB ERA13WA030](https://openairdocs.org/ntsb/ERA13WA030.md): Piper PA25 · Juquiá Municipality, Brazil · Accident · 1 fatal · Foreign investigation · Oct 3, 2012 · PT-DOX · Destroyed
  > On October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…
- [NTSB ERA13WA085](https://openairdocs.org/ntsb/ERA13WA085.md): Thrush S2R-T34 · Naranjal, Ecuador · Accident · No injuries · Foreign investigation · Oct 2, 2012 · HC-CFU · Substantial damage
  > On October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…
- [NTSB WPR12LA442](https://openairdocs.org/ntsb/WPR12LA442.md): Air Creation Tanarg · Safford, AZ · Accident · 1 fatal · Limited investigation · Final report · Sep 30, 2012 · N2751N · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.
- [NTSB CEN12LA669](https://openairdocs.org/ntsb/CEN12LA669.md): Robinson Helicopter R44 · Nocona, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2012 · N8341W · Substantial damage
  > The noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.
- [NTSB CEN12FA670](https://openairdocs.org/ntsb/CEN12FA670.md): Agusta A109E · Eastland, TX · Accident · Serious injuries · Field investigation · Final report · Sep 30, 2012 · N144CF · Substantial damage
  > The loss of helicopter control after an in-flight upset, which occurred when the pilot selected the autopilot’s altitude hold mode; the reason for the reported in-flight control anomaly could not be determined during postaccident helicopter examinations.…
- [NTSB ERA12LA578](https://openairdocs.org/ntsb/ERA12LA578.md): Cessna 172B · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Sep 23, 2012 · N8059X · Substantial damage
  > The pilot’s suicidal act.
- [NTSB WPR12LA426](https://openairdocs.org/ntsb/WPR12LA426.md): Bell 206 - B · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 2012 · N222GR · Destroyed
  > The pilot’s inability to maintain sufficient main rotor rpm while maneuvering in high density altitude conditions, which resulted in a precautionary landing and subsequent rollover.
- [NTSB CEN12LA650](https://openairdocs.org/ntsb/CEN12LA650.md): Hiller UH-12B · Rio Vista, TX · Accident · No injuries · Limited investigation · Final report · Sep 19, 2012 · N94735 · Substantial damage
  > The catastrophic failure and disintegration of the No. 6 engine piston, which resulted in a total loss of engine power.
- [NTSB ANC12LA107](https://openairdocs.org/ntsb/ANC12LA107.md): Piper PA-22-160 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2012 · N8433D · Substantial damage
  > The flight instructor's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an inadvertent stall.
- [NTSB WPR12LA428](https://openairdocs.org/ntsb/WPR12LA428.md): Rockwell International 690A · Ellensburg, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 2012 · N57112 · Substantial damage
  > The pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.
- [NTSB ERA12FA565](https://openairdocs.org/ntsb/ERA12FA565.md): Yakovlev YAK 52 · Brownsboro, AL · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2012 · N2207X · Substantial damage
  > The pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?year=2012&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2012
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?year=2012

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.