# NTSB investigations, 2012: Initial climb

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 4 · 193 cases

## Latest cases

- [NTSB CEN13LA118](https://openairdocs.org/ntsb/CEN13LA118.md): Piper PA-24-250 · Mc Allen, TX · Accident · No injuries · Limited investigation · Final report · Dec 31, 2012 · N8053P · Substantial damage
  > A loss of engine power due to carburetor icing.
- [NTSB CEN13CA117](https://openairdocs.org/ntsb/CEN13CA117.md): Embraer EMB-145LR · Chicago, IL · Accident · Serious injuries · Data collection · Final report · Dec 29, 2012 · N619AE · No damage
  > The presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.
- [NTSB CEN13LA116](https://openairdocs.org/ntsb/CEN13LA116.md): Seguine Swift II · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 24, 2012 · N84NS · Substantial damage
  > The pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA13LA099](https://openairdocs.org/ntsb/ERA13LA099.md): Piper PA-28RT-201T · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 2012 · N4340G · Substantial damage
  > The pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.
- [NTSB ERA13LA093](https://openairdocs.org/ntsb/ERA13LA093.md): Russom Roy G Hummel H5 · Calhoun, GA · Accident · 1 fatal · Limited investigation · Final report · Dec 18, 2012 · N156FH · Substantial damage
  > The pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.
- [NTSB ERA13LA084](https://openairdocs.org/ntsb/ERA13LA084.md): Merritt Leslie R Kelly D · Brandon, MS · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2012 · N5172S · Substantial damage
  > A total loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13FA082](https://openairdocs.org/ntsb/ERA13FA082.md): Cessna 421C · Lake Worth, FL · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2012 · N297DB · Substantial damage
  > The pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…
- [NTSB CEN13FA101](https://openairdocs.org/ntsb/CEN13FA101.md): Cessna 501 · Detroit Lakes, MN · Accident · No injuries · Field investigation · Final report · Dec 8, 2012 · N212M · Substantial damage
  > A loss of airplane control due to an undetermined avionics malfunction and the pilots’ inattention, which resulted in excessive airframe forces during the unusual attitude recovery. The reason for the avionics malfunction could not be determined because…
- [NTSB ANC13LA012](https://openairdocs.org/ntsb/ANC13LA012.md): Cessna 208B · Mekoryuk, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2012 · N169LJ · Substantial damage
  > The total loss of engine power as a result of a fractured first-stage compressor blade due to fatigue cracking. The source of the fatigue crack could not be determined due to secondary damage sustained to the fracture surface.
- [NTSB CEN13FA080](https://openairdocs.org/ntsb/CEN13FA080.md): Cessna 208B · Bryans Corner, OK · Accident · Minor injuries · Field investigation · Final report · Nov 30, 2012 · N1324G · Substantial damage
  > The total loss of engine power as a result of a fractured compressor turbine blade due to fatigue cracking.
- [NTSB WPR13LA060](https://openairdocs.org/ntsb/WPR13LA060.md): Piper PA30 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 24, 2012 · N8747Y · Substantial damage
  > The pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…
- [NTSB CEN13FA069](https://openairdocs.org/ntsb/CEN13FA069.md): Cessna 310B · Mancelona, MI · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2012 · N5419A · Substantial damage
  > The pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.
- [NTSB WPR13LA047](https://openairdocs.org/ntsb/WPR13LA047.md): Cessna 210 · San Rafael, CA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2012 · N3919Y · Substantial damage
  > The loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13LA045](https://openairdocs.org/ntsb/WPR13LA045.md): Piper PA-32 · Obyan · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 2012 · N4267R · Substantial damage
  > A partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…
- [NTSB CEN13LA062](https://openairdocs.org/ntsb/CEN13LA062.md): Jabiru USA Sport J250-SP · Jacksonville, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 2012 · N635J · Substantial damage
  > The pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.
- [NTSB ANC13WA010](https://openairdocs.org/ntsb/ANC13WA010.md): Cessna 208 · Snow Lake, Canada · Accident · 1 fatal · Foreign investigation · Nov 18, 2012 · C-GAGP · Substantial damage
  > On November 18, 2012, about 1000 central standard time, a Cessna 208B airplane, (Canadian Registration C-GAGP) was on a VFR flight plan from Snow Lake (CJE4) to Winnipeg (CYWG), Manitoba, Canada. The airplane crashed in a wooded area near the Snow Lake…
- [NTSB WPR13FA041](https://openairdocs.org/ntsb/WPR13FA041.md): American AA-1 · Morgan, UT · Accident · 1 fatal · Field investigation · Final report · Nov 15, 2012 · N5642L · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in frost remaining on the airplane's surfaces and led to its inability to produce enough lift to clear rising terrain.
- [NTSB ERA13FA055](https://openairdocs.org/ntsb/ERA13FA055.md): Piper PA-32-300 · Jackson, MS · Accident · 3 fatal · Field investigation · Final report · Nov 13, 2012 · N717RL · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in his failure to note the water in the fuel tank due to condensation, which subsequently shut down the engine in flight. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB WPR13LA038](https://openairdocs.org/ntsb/WPR13LA038.md): Cessna 172P · Maricopa, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2012 · N65835 · Substantial damage
  > The pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.
- [NTSB CEN13WA061](https://openairdocs.org/ntsb/CEN13WA061.md): Reims-Cessna F150 · Birr, Ireland, Ireland · Accident · 2 fatal · Foreign investigation · Nov 11, 2012 · EI-AST · Destroyed
  > On November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…
- [NTSB ENG13IA005](https://openairdocs.org/ntsb/ENG13IA005.md): Boeing MD-88 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Nov 7, 2012 · N908DE · No damage
  > The 4th stage turbine blade separation that resulted in an uncontained release of low pressure turbine blade material was Delta Air Lines' repair process for the turbine blades' tip shrouds. It was not possible to identify the part of the repair process that…
- [NTSB CEN13LA046](https://openairdocs.org/ntsb/CEN13LA046.md): Sorensen Sprint Mxii · Groesbeck, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 5, 2012 · N460JS · Minor damage
  > The pilot’s failure to maintain control of the noncertificated airplane during a go-around. Contributing to the accident was the pilot’s physical and psychological impairment.
- [NTSB CEN13LA055](https://openairdocs.org/ntsb/CEN13LA055.md): Central Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OH · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2012 · N667DF · Substantial damage
  > The total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.
- [NTSB ANC13LA008](https://openairdocs.org/ntsb/ANC13LA008.md): Bellanca 7ECA · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Nov 4, 2012 · N31281 · Substantial damage
  > The loss of engine power due to carburetor icing and the pilot's failure to apply carburetor heat when he reduced engine power.
- [NTSB CEN13FA039](https://openairdocs.org/ntsb/CEN13FA039.md): Cessna 320E · San Marcos, TX · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2012 · N10PM · Substantial damage
  > The non-instrument-rated pilot’s decision to takeoff in night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB CEN13CA033](https://openairdocs.org/ntsb/CEN13CA033.md): Porter James Grant Superior CUB · Beechgrove, IN · Accident · Serious injuries · Data collection · Final report · Oct 27, 2012 · N97RP · Substantial damage
  > The pilot’s failure to maintain clearance from trees during takeoff from a short field.
- [NTSB ERA13LA034](https://openairdocs.org/ntsb/ERA13LA034.md): Cessna 150H · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · Oct 21, 2012 · N7250S · Substantial damage
  > The pilots’ failure to apply carburetor heat during takeoff, which resulted in a partial loss of engine power due to the formation of carburetor ice.
- [NTSB CEN13WA020](https://openairdocs.org/ntsb/CEN13WA020.md): Mooney M20E · Speichersdorf, Germany · Accident · 2 fatal · Foreign investigation · Oct 21, 2012 · D-EMHE · Destroyed
  > On October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…
- [NTSB WPR13CA019](https://openairdocs.org/ntsb/WPR13CA019.md): Quicksilver Mfg MXL II Sport · Live Oak, CA · Accident · Serious injuries · Data collection · Final report · Oct 20, 2012 · N187AB · Substantial damage
  > The pilot’s failure to compensate for turbulent conditions, which resulted in a loss of altitude.
- [NTSB ERA13IA036](https://openairdocs.org/ntsb/ERA13IA036.md): Cessna 560XL · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Oct 19, 2012 · N576QS · Minor damage
  > The incorrect installation of the left main gear aft trunnion pivot pin by maintenance personnel, which resulted in separation of the aft portion of the left main gear trunnion from the aft trunnion fitting and minor damage to the airplane.
- [NTSB ERA13FA026](https://openairdocs.org/ntsb/ERA13FA026.md): Aerospatiale AS 355 · Erwinna, PA · Accident · 1 fatal · Field investigation · Final report · Oct 17, 2012 · C-FXGM · Substantial damage
  > The pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.
- [NTSB ERA13LA024](https://openairdocs.org/ntsb/ERA13LA024.md): Cashmer Philip M Sonex · Crossville, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2012 · N198PC · Substantial damage
  > The pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…
- [NTSB WPR13FA013](https://openairdocs.org/ntsb/WPR13FA013.md): Aeropro CZ A240 · Half Moon Bay, CA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N72AH · Substantial damage
  > The non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.
- [NTSB ERA13LA020](https://openairdocs.org/ntsb/ERA13LA020.md): Airborne Windsports PTY XT-912 · Winter Haven, FL · Accident · 2 fatal · Limited investigation · Final report · Oct 14, 2012 · N811RW · Destroyed
  > The pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.
- [NTSB ERA13LA025](https://openairdocs.org/ntsb/ERA13LA025.md): Piper PA-28-140 · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N15037 · Substantial damage
  > The operator's failure to perform magneto inspections per the manufacturer's recommendations and failure to comply with the engine manufacturer's recommended time interval for engine overhaul, which resulted in defects in the magnetos going undetected and the…
- [NTSB ERA13LA015](https://openairdocs.org/ntsb/ERA13LA015.md): Velline'S Breezy RLU-1 · Madison, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 2012 · N255JL · Substantial damage
  > The pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…
- [NTSB ENG13WA001](https://openairdocs.org/ntsb/ENG13WA001.md): Beech 1900 · Lyon, France · Incident · No injuries · Foreign investigation · Oct 9, 2012 · F-GOPE · No damage
  > On October 09, 2012, at 9:40 am local time, a Beechcraft 1900, F-GOPE, operated by Hex'Air, experienced a elevator trim system failure after take-off at Lyon-Saint Exupery airport(LFLL), France. A post flight inspection revealed that the elevator trim forward…
- [NTSB ANC13CA003](https://openairdocs.org/ntsb/ANC13CA003.md): Cessna 172D · Buckland, AK · Accident · No injuries · Data collection · Final report · Oct 8, 2012 · N8808 · Substantial damage
  > The pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.
- [NTSB CEN13IA008](https://openairdocs.org/ntsb/CEN13IA008.md): Mueller Michael Walter Challenger II CW SPC · Sandwich, IL · Incident · No injuries · Incident investigation · Final report · Oct 7, 2012 · N530MW · Minor damage
  > A total loss of engine power due to significant engine corrosion. Contributing to the accident was inadequate engine maintenance.
- [NTSB ERA13LA013](https://openairdocs.org/ntsb/ERA13LA013.md): Beaudry Phillip Aventura II · Minneola, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2012 · N4401P · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13FA003](https://openairdocs.org/ntsb/CEN13FA003.md): Bell 407 · Intracoastal City, LA · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2012 · N406AL · Substantial damage
  > The pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.
- [NTSB ERA13CA009](https://openairdocs.org/ntsb/ERA13CA009.md): Powrachute Pegasus · Cumming, GA · Accident · Minor injuries · Data collection · Final report · Oct 4, 2012 · N580PG · Substantial damage
  > The operation of the powered parachute by a non-certificated pilot, and his failure to maintain directional control during the initial climb, which resulted in a collision with trees.
- [NTSB ERA12FA583](https://openairdocs.org/ntsb/ERA12FA583.md): Cessna 150M · Fredericksburg, VA · Accident · 2 fatal · Field investigation · Final report · Sep 29, 2012 · N66246 · Substantial damage
  > The pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.
- [NTSB ERA12CA588](https://openairdocs.org/ntsb/ERA12CA588.md): Henrie Raymond Zenith CH 701 Stol · Ashland, MS · Accident · Minor injuries · Data collection · Final report · Sep 29, 2012 · N234RH · Substantial damage
  > The pilot’s inadequate compensation for crosswind conditions during initial climb, which resulted in an impact with trees and terrain.
- [NTSB CEN12LA678](https://openairdocs.org/ntsb/CEN12LA678.md): Infinity 2003 · Merrill, MI · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 2012 · N70319 · Substantial damage
  > The pilot's improper decision to attempt a takeoff from midfield, resulting in a collision with trees at the departure end of the field.
- [NTSB WPR12LA437](https://openairdocs.org/ntsb/WPR12LA437.md): Mccleery Rans S6ES · Elverta, CA · Accident · No injuries · Limited investigation · Final report · Sep 25, 2012 · N623LB · Substantial damage
  > A loss of engine power during initial climb due to a failed piston ring.
- [NTSB ERA12WA590](https://openairdocs.org/ntsb/ERA12WA590.md): Piper PA34 · Ilheus, Brazil · Accident · 1 fatal · Foreign investigation · Sep 25, 2012 · PT-RDG · Substantial damage
  > On September 25, 2012, about 0155 universal coordinated time, a Piper PA-34-200T, Brazilian registration PT-RDG, was substantially damaged when it impacted the Atlantic Ocean, shortly after takeoff from the Ilheus Jorge Amado Airport (SBIL), Ilheus, Bahia,…
- [NTSB ERA12WA591](https://openairdocs.org/ntsb/ERA12WA591.md): Cessna 210 · Roraima, Brazil · Accident · 1 fatal · Foreign investigation · Sep 24, 2012 · PT-KSB · Substantial damage
  > On September 24, 2012, about 0400 hours local, or 0800 UTC, a Cessna 210L, Brazilian registration PT-KSB, departed controlled flight and crashed shortly after takeoff from Pouso Da Aguilia Airport (SWPD), Roraima, Brazil. Visual meteorological conditions…
- [NTSB WPR12LA434](https://openairdocs.org/ntsb/WPR12LA434.md): Navion Navion · Lompoc, CA · Accident · No injuries · Limited investigation · Final report · Sep 23, 2012 · N4418K · Substantial damage
  > A total loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12LA433](https://openairdocs.org/ntsb/WPR12LA433.md): Air Tractor AT-502 · Firebaugh, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 2012 · N4556S · Substantial damage
  > The pilot’s decision to continue the takeoff after the engine stopped producing its full-rated torque while operating in high-density altitude conditions and his subsequent failure to maintain clearance from the power transmission wires.

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.