# NTSB investigations, 2012: Enroute

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 7 · 309 cases

## Latest cases

- [NTSB WPR13FA076](https://openairdocs.org/ntsb/WPR13FA076.md): Mckenzie Lancair IV-P Turbine · Lakeside, CA · Accident · 3 fatal · Field investigation · Final report · Dec 29, 2012 · N5M · Substantial damage
  > The pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.
- [NTSB CEN13LA119](https://openairdocs.org/ntsb/CEN13LA119.md): Bell 407 · Big Lake, TX · Accident · No injuries · Limited investigation · Final report · Dec 29, 2012 · N534MT · Substantial damage
  > The loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.
- [NTSB ERA13FA096](https://openairdocs.org/ntsb/ERA13FA096.md): Piper PA-31-350 · Leesburg, FL · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2012 · N78WM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…
- [NTSB ERA13LA097](https://openairdocs.org/ntsb/ERA13LA097.md): Piper PA-28R-200 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2012 · N2074T · Substantial damage
  > The reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…
- [NTSB CEN13LA110](https://openairdocs.org/ntsb/CEN13LA110.md): Beech 95-B55 (T42A) · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2012 · N30WC · Substantial damage
  > The pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.
- [NTSB WPR13FA072](https://openairdocs.org/ntsb/WPR13FA072.md): Piper PA-31-350 · Payson, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2012 · N62959 · Substantial damage
  > The airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…
- [NTSB ERA13LA094](https://openairdocs.org/ntsb/ERA13LA094.md): Wragg George Skybolt · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 2012 · N328GW · Substantial damage
  > The pilot's inadequate preflight planning and failure to monitor the fuel quantity during flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN13LA111](https://openairdocs.org/ntsb/CEN13LA111.md): Piper L-18C · Graham, TX · Accident · No injuries · Limited investigation · Final report · Dec 19, 2012 · N3134G · Substantial damage
  > The failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.
- [NTSB WPR13FA312](https://openairdocs.org/ntsb/WPR13FA312.md): Mooney M20F · Yosemite Valley, CA · Accident · 1 fatal · Field investigation · Final report · Dec 17, 2012 · N9524M · Substantial damage
  > The pilot’s decision to continue flight into instrument meteorological conditions, which resulted in his failure to maintain situational awareness and sufficient altitude to clear mountainous terrain.
- [NTSB WPR13FA070](https://openairdocs.org/ntsb/WPR13FA070.md): Piper PA-31T1 · Ely, NV · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N93CN · Destroyed
  > The pilot’s failure to regain airplane control following a sudden rapid descent during cruise flight, which resulted in an exceedance of the design stress limits of the aircraft and led to an in-flight structural failure.
- [NTSB CEN13FA105](https://openairdocs.org/ntsb/CEN13FA105.md): Beech E-90 · Amarillo, TX · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N67PS · Substantial damage
  > The pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.
- [NTSB ANC13FA017](https://openairdocs.org/ntsb/ANC13FA017.md): Eurocopter AS350 B3 · Beluga, AK · Accident · Serious injuries · Field investigation · Final report · Dec 15, 2012 · C-GYPH · Substantial damage
  > The pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…
- [NTSB ERA13WA089](https://openairdocs.org/ntsb/ERA13WA089.md): Piper PA34 · Zulia, Colombia · Accident · 4 fatal · Foreign investigation · Dec 12, 2012 · HK4477G · Destroyed
  > On December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…
- [NTSB ERA13FA083](https://openairdocs.org/ntsb/ERA13FA083.md): Diamond Aircraft Ind DA 40 · Lake Park, GA · Accident · 1 fatal · Field investigation · Final report · Dec 11, 2012 · N840DS · Substantial damage
  > The noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.
- [NTSB CEN13LA103](https://openairdocs.org/ntsb/CEN13LA103.md): Auman JL T-51 · Dekalb, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 2012 · N512JA · Substantial damage
  > The improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.
- [NTSB CEN13FA096](https://openairdocs.org/ntsb/CEN13FA096.md): MBB BK 117 A-3 · Compton, IL · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2012 · N911BK · Substantial damage
  > The inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.
- [NTSB DCA13RA025](https://openairdocs.org/ntsb/DCA13RA025.md): Learjet 25 · Monterrey, Mexico · Accident · 7 fatal · Foreign investigation · Dec 9, 2012 · N345MC · Destroyed
- [NTSB CEN13WA092](https://openairdocs.org/ntsb/CEN13WA092.md): Piper PA-32-301 · Melbach, Germany · Accident · 8 fatal · Foreign investigation · Dec 8, 2012 · D-EUEU · 2 aircraft · Substantial damage
  > On December 8, 2012, about 1513 coordinated universal time, a Piper PA-32, German registration, D-EUEU, and a Robin Regent DR400, German registration D-EHJP, collided while on cross country flights near Melbach, Germany. Visual meteorological conditions…
- [NTSB WPR13CA064](https://openairdocs.org/ntsb/WPR13CA064.md): Robinson Helicopter R44 II · Roosevelt Lake, AZ · Accident · Serious injuries · Data collection · Final report · Dec 7, 2012 · N557AC · Substantial damage
  > The pilot's visual disorientation, which resulted in a collision with the lake.
- [NTSB CEN13LA104](https://openairdocs.org/ntsb/CEN13LA104.md): Cessna 172M · Arcola, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2012 · N172BJ · Substantial damage
  > The loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA095](https://openairdocs.org/ntsb/CEN13LA095.md): Mooney M20E · Gurdon, AR · Accident · No injuries · Limited investigation · Final report · Dec 5, 2012 · N9493V · Substantial damage
  > The total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.
- [NTSB CEN13LA091](https://openairdocs.org/ntsb/CEN13LA091.md): Stinson 108-2 · Halfway, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2012 · N8775K · Substantial damage
  > The pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.
- [NTSB DCA13WA160](https://openairdocs.org/ntsb/DCA13WA160.md): Boeing Boeing 777-236 · Shannon, Ireland · Incident · No injuries · Foreign investigation · Dec 2, 2012 · G-VIIK · Minor damage
  > The Air Accident Investigations Unit of Ireland has notified the NTSB of an incident involving a Boeing 777 that occurred on December 02, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-I investigation under the provisions of…
- [NTSB ERA13LA072](https://openairdocs.org/ntsb/ERA13LA072.md): Hansen David Daniel RV-4 · Carthage, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2012 · N416DH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…
- [NTSB ERA13FA071](https://openairdocs.org/ntsb/ERA13FA071.md): Green Gary E Thorp T-18 · Pahokee, FL · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2012 · N118GG · Substantial damage
  > The descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.
- [NTSB ERA13FA070](https://openairdocs.org/ntsb/ERA13FA070.md): Robinson Helicopter R22 Beta II · Apollo Beach, FL · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2012 · N2626N · Substantial damage
  > Mast bumping for reasons that could not be determined because one main rotor blade was not recovered.
- [NTSB CEN13FA073](https://openairdocs.org/ntsb/CEN13FA073.md): Cessna 421C · Wells, TX · Accident · 1 fatal · Field investigation · Final report · Nov 27, 2012 · N67SR · Substantial damage
  > The pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.
- [NTSB WPR13LA052](https://openairdocs.org/ntsb/WPR13LA052.md): Cessna U206 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2012 · N5229U · Substantial damage
  > A partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.
- [NTSB WPR13FA061](https://openairdocs.org/ntsb/WPR13FA061.md): Piper PA28 · Aurora, UT · Accident · 3 fatal · Field investigation · Final report · Nov 25, 2012 · N8314E · Substantial damage
  > The pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…
- [NTSB CEN13LA072](https://openairdocs.org/ntsb/CEN13LA072.md): Beech S35 · DeRidder, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 2012 · N322D · Substantial damage
  > A total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…
- [NTSB DCA13WA031](https://openairdocs.org/ntsb/DCA13WA031.md): Boeing 737 · Bogota, Colombia · Incident · No injuries · Foreign investigation · Nov 24, 2012 · HP1371CM · No damage
  > On 24 November, 2012, at approxiumately 1636 UTC time, a Boeing B737-7V3, registration HP1371CM, operated by Copa Airlines Columbia between Bogota and Cartegna, Coulmbia, experienced a depressurization while climbing through FL240 and the oxygen masks…
- [NTSB ERA13WA078](https://openairdocs.org/ntsb/ERA13WA078.md): Cessna R172K · Cuchilla La Laja, Colombia · Accident · 1 fatal · Foreign investigation · Nov 19, 2012 · HK4890G · Substantial damage
  > On November 19, 2012, about 1030 hours local, a Cessna R172K, Colombian registration HK4890G, collided with mountainous terrain near Cuchilla La Laja – Municipio de San Francisco, Departmento de Cundinamarca, Colombia. Instrument meteorological conditions…
- [NTSB WPR13FA053](https://openairdocs.org/ntsb/WPR13FA053.md): Cessna 182D · Bondurant, WY · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2012 · N61LN · Destroyed
  > The noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.
- [NTSB WPR13LA043](https://openairdocs.org/ntsb/WPR13LA043.md): Cirrus SR22 · Show Low, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2012 · N800RW · Substantial damage
  > The fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.
- [NTSB WPR13IA059](https://openairdocs.org/ntsb/WPR13IA059.md): Bell 407 · Riverton, WY · Incident · No injuries · Incident investigation · Final report · Nov 15, 2012 · N7160V · Minor damage
  > The pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.
- [NTSB ERA13LA056](https://openairdocs.org/ntsb/ERA13LA056.md): Piper PA-18-150 · Canton, GA · Accident · No injuries · Limited investigation · Final report · Nov 13, 2012 · N9764P · Substantial damage
  > A partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.
- [NTSB WPR13FA037](https://openairdocs.org/ntsb/WPR13FA037.md): Cessna 421C · Shaver Lake, CA · Accident · 2 fatal · Field investigation · Final report · Nov 11, 2012 · N700EM · Substantial damage
  > The pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…
- [NTSB ANC13LA009](https://openairdocs.org/ntsb/ANC13LA009.md): Piper PA-18-150 · Akiachak, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2012 · N8466Y · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and the pilot’s failure to maintain adequate airspeed during the subsequent forced landing, which resulted in an inadvertent stall.
- [NTSB ERA13LA052](https://openairdocs.org/ntsb/ERA13LA052.md): Waller Charles R Rans S12-XL · Gordon, AL · Accident · No injuries · Limited investigation · Final report · Nov 10, 2012 · N933CW · Substantial damage
  > A fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.
- [NTSB CEN13LA054](https://openairdocs.org/ntsb/CEN13LA054.md): Cessna P210N · Conway, AR · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2012 · N887JA · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…
- [NTSB CEN13FA049](https://openairdocs.org/ntsb/CEN13FA049.md): Cessna 208B · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2012 · N793FE · Substantial damage
  > The total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.
- [NTSB ERA13WA068](https://openairdocs.org/ntsb/ERA13WA068.md): Embraer 810D · Chapada dos Guimaraes, Brazil · Accident · 4 fatal · Foreign investigation · Nov 1, 2012 · PT-VRV · Substantial damage
  > On November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…
- [NTSB ERA13WA050](https://openairdocs.org/ntsb/ERA13WA050.md): Cessna 206 · Kiim, Ecuador · Accident · Serious injuries · Foreign investigation · Oct 31, 2012 · HC-CBG · Substantial damage
  > On October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…
- [NTSB WPR13CA027](https://openairdocs.org/ntsb/WPR13CA027.md): Robinson Helicopter R22 Beta · Hanapepe, HI · Accident · No injuries · Data collection · Final report · Oct 29, 2012 · N216AB · Substantial damage
  > The pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.
- [NTSB ERA13LA042](https://openairdocs.org/ntsb/ERA13LA042.md): Piper PA-32R-300 · Sevierville, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2012 · N4478F · Substantial damage
  > The air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…
- [NTSB ERA13FA039](https://openairdocs.org/ntsb/ERA13FA039.md): Beech A36 · Hooksett, NH · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2012 · N4325W · Substantial damage
  > The pilot's total incapacitation in flight due to an acute heart attack.
- [NTSB DCA13WA015](https://openairdocs.org/ntsb/DCA13WA015.md): Boeing 737 · Brasilia, Brazil · Incident · No injuries · Foreign investigation · Oct 24, 2012 · PR-WJD · No damage
  > The Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA), has notified the NTSB of an incident involving a Boeing 737 that occurred on October 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…
- [NTSB WPR13LA015](https://openairdocs.org/ntsb/WPR13LA015.md): Beech N35 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Oct 18, 2012 · N671VC · Substantial damage
  > A loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.
- [NTSB WPR13CA016](https://openairdocs.org/ntsb/WPR13CA016.md): Boeing 737-3H4 · Las Vegas, NV · Accident · Serious injuries · Data collection · Final report · Oct 17, 2012 · N625SW · No damage
  > The flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.
- [NTSB ERA13WA031](https://openairdocs.org/ntsb/ERA13WA031.md): Robinson R-44 · Moscow, Russia · Accident · 1 fatal · Foreign investigation · Oct 16, 2012 · RA-04206 · Substantial damage
  > None

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

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