# NTSB investigations, 2012: Approach

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

## Latest cases

- [NTSB ERA13WA103](https://openairdocs.org/ntsb/ERA13WA103.md): Piper PA28 · Minas City, Brazil · Accident · 2 fatal · Foreign investigation · Dec 26, 2012 · PR-NAX · Destroyed
  > On December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…
- [NTSB DCA13WA041](https://openairdocs.org/ntsb/DCA13WA041.md): Fokker 100 · Heho, Myanmar (Burma) · Accident · Serious injuries · Foreign investigation · Dec 25, 2012 · XY-AGC · Substantial damage
  > On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and…
- [NTSB WPR13FA074](https://openairdocs.org/ntsb/WPR13FA074.md): Charland Vortex · Wellton, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2012 · N618TC · Substantial damage
  > The pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.
- [NTSB CEN13TA113](https://openairdocs.org/ntsb/CEN13TA113.md): Cessna 550 · Oklahoma City, OK · Accident · Minor injuries · Final report · Dec 21, 2012 · N753CC · Substantial damage
  > The flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…
- [NTSB CEN13LA109](https://openairdocs.org/ntsb/CEN13LA109.md): Beech A23 · Grand Isle, NE · Accident · No injuries · Limited investigation · Final report · Dec 18, 2012 · N3573R · Substantial damage
  > The student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA13FA088](https://openairdocs.org/ntsb/ERA13FA088.md): Piper PA-28-160 · Parkton, NC · Accident · 1 fatal · Field investigation · Final report · Dec 16, 2012 · N5714W · Substantial damage
  > The failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of…
- [NTSB CEN13CA106](https://openairdocs.org/ntsb/CEN13CA106.md): Cessna 182Q · Bellview, TX · Accident · No injuries · Data collection · Final report · Dec 15, 2012 · N735BV · Substantial damage
  > The pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.
- [NTSB WPR13CA065](https://openairdocs.org/ntsb/WPR13CA065.md): Bellanca 7ECA · Tehachapi, CA · Accident · No injuries · Data collection · Final report · Dec 8, 2012 · N8595V · Substantial damage
  > The non-instrument-rated pilot's continued descent into instrument meteorological conditions during the landing approach and his loss of situational awareness, which resulted in a collision with terrain.
- [NTSB CEN13LA097](https://openairdocs.org/ntsb/CEN13LA097.md): North American T-28C · Moody, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2012 · N280JM · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA099](https://openairdocs.org/ntsb/CEN13LA099.md): Enstrom F-28C · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2012 · N574H · Substantial damage
  > The flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate…
- [NTSB CEN13LA094](https://openairdocs.org/ntsb/CEN13LA094.md): Lsa America Allegro · Adrian, MI · Accident · No injuries · Limited investigation · Final report · Dec 6, 2012 · N448SS · Substantial damage
  > The student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions.
- [NTSB DCA13CA066](https://openairdocs.org/ntsb/DCA13CA066.md): Bombardier CL-600-2B19 · New York, NY · Accident · No injuries · Data collection · Final report · Dec 5, 2012 · N411ZW · Substantial damage
  > an inadvertant birdstrike on approach.
- [NTSB CEN13LA088](https://openairdocs.org/ntsb/CEN13LA088.md): Cessna 172M · Rochester, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2012 · N9853Q · Substantial damage
  > The pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…
- [NTSB ERA13LA076](https://openairdocs.org/ntsb/ERA13LA076.md): Cassutt Sport Racer · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N9CA · Substantial damage
  > Impact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.
- [NTSB ERA13CA077](https://openairdocs.org/ntsb/ERA13CA077.md): Schweizer SGS 2-33A · Middletown, NY · Accident · No injuries · Data collection · Final report · Dec 2, 2012 · N5787S · Substantial damage
  > The pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.
- [NTSB CEN13CA083](https://openairdocs.org/ntsb/CEN13CA083.md): Mooney M20TN · Durango, CO · Accident · No injuries · Data collection · Final report · Dec 2, 2012 · N562BG · Substantial damage
  > The pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.
- [NTSB ERA13CA073](https://openairdocs.org/ntsb/ERA13CA073.md): Beech B19 · Fort Lauderdale, FL · Accident · No injuries · Data collection · Final report · Dec 1, 2012 · N2196W · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB CEN13FA081](https://openairdocs.org/ntsb/CEN13FA081.md): Ercoupe 415-C · Blair, NE · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2012 · N720RC · Substantial damage
  > The pilot's loss of control due to physical incapacitation.
- [NTSB ERA13LA069](https://openairdocs.org/ntsb/ERA13LA069.md): Lawson J/Bowie R/Smith M CA-8 · Merritt Island, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2012 · N155JD · Substantial damage
  > The pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…
- [NTSB CEN13FA078](https://openairdocs.org/ntsb/CEN13FA078.md): Taylorcraft BC12-D · Clutier, IA · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2012 · N94973 · Substantial damage
  > The pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…
- [NTSB CEN13FA067](https://openairdocs.org/ntsb/CEN13FA067.md): Piper PA-28-180 · Hillsdale, MI · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2012 · N40781 · Substantial damage
  > The pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…
- [NTSB CEN13FA066](https://openairdocs.org/ntsb/CEN13FA066.md): Brian P North RAF SE5A Replica · Watkins, CO · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2012 · N17SE · Substantial damage
  > The pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.
- [NTSB ERA13LA065](https://openairdocs.org/ntsb/ERA13LA065.md): Beech C90A · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2012 · N702DK · Substantial damage
  > The failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…
- [NTSB ERA13FA064](https://openairdocs.org/ntsb/ERA13FA064.md): Piper PA-28-180 · Canton, CT · Accident · 2 fatal · Field investigation · Final report · Nov 19, 2012 · N8826J · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.
- [NTSB CEN13LA063](https://openairdocs.org/ntsb/CEN13LA063.md): Redd Tom Quicksilver GT 400 · Oak Grove, LA · Accident · 1 fatal · Limited investigation · Final report · Nov 19, 2012 · N4031Q · Substantial damage
  > The total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.
- [NTSB ERA13FA062](https://openairdocs.org/ntsb/ERA13FA062.md): Cessna 172K · Savannah, GA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2012 · N78304 · Substantial damage
  > The pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.
- [NTSB ERA13LA060](https://openairdocs.org/ntsb/ERA13LA060.md): Beech 35B33 · White Plains, NY · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 2012 · N8519M · Substantial damage
  > The pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.
- [NTSB ERA13LA058](https://openairdocs.org/ntsb/ERA13LA058.md): Cessna 172RG · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Nov 15, 2012 · N9985B · Substantial damage
  > The rupture of the landing gear’s hydraulic pressure hose, which resulted in the depletion of all of the hydraulic fluid, and the inability of the landing gear to raise or lower. Contributing to the accident was the installation of an unapproved hydraulic…
- [NTSB ERA13LA053](https://openairdocs.org/ntsb/ERA13LA053.md): Cessna 210 · Jasper, GA · Accident · No injuries · Limited investigation · Final report · Nov 11, 2012 · N9633T · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…
- [NTSB ERA13LA054](https://openairdocs.org/ntsb/ERA13LA054.md): Vans RV-12 · Williamson, GA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2012 · N678AD · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.
- [NTSB ERA13WA074](https://openairdocs.org/ntsb/ERA13WA074.md): Piper PA-31T · Curitiba, Brazil · Accident · 4 fatal · Foreign investigation · Nov 6, 2012 · PT-MFW · Destroyed
  > On November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…
- [NTSB CEN13FA045](https://openairdocs.org/ntsb/CEN13FA045.md): Cessna 150F · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Nov 4, 2012 · N8375G · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN13LA041](https://openairdocs.org/ntsb/CEN13LA041.md): Cessna 172S · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2012 · N985GE · Substantial damage
  > The student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…
- [NTSB CEN13FA030](https://openairdocs.org/ntsb/CEN13FA030.md): Piper PA-28-140 · Maryland Heights, MO · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2012 · N55620 · Substantial damage
  > The pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.
- [NTSB CEN13LA029](https://openairdocs.org/ntsb/CEN13LA029.md): Quad City Challenger · Castroville, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 23, 2012 · UNREG · Substantial damage
  > The pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.
- [NTSB CEN13LA016](https://openairdocs.org/ntsb/CEN13LA016.md): Beech A36 · Wausau, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2012 · N121VP · Substantial damage
  > The pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.
- [NTSB WPR13LA009](https://openairdocs.org/ntsb/WPR13LA009.md): Piper PA-38-112 · Corona, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2012 · N4309E · Substantial damage
  > Total loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.
- [NTSB ERA13LA018](https://openairdocs.org/ntsb/ERA13LA018.md): Sikorsky S-55B · Yorktown, NY · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N443FD · Substantial damage
  > The pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.
- [NTSB ERA13WA108](https://openairdocs.org/ntsb/ERA13WA108.md): Sikorsky S61 · Carauari, Brazil · Incident · No injuries · Foreign investigation · Oct 10, 2012 · PR-HRU · No damage
  > On October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…
- [NTSB ANC13CA002](https://openairdocs.org/ntsb/ANC13CA002.md): Cessna U206F · Buckland, AK · Accident · No injuries · Data collection · Final report · Oct 9, 2012 · N9575G · Substantial damage
  > The pilot's loss of airplane control during final approach in gusty wind conditions.
- [NTSB WPR13LA005](https://openairdocs.org/ntsb/WPR13LA005.md): Cessna 180H · St Maries, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 2012 · N2780X · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA012](https://openairdocs.org/ntsb/ERA13LA012.md): Cirrus Design SR22 · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2012 · N80KW · Substantial damage
  > The pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…
- [NTSB WPR13LA002](https://openairdocs.org/ntsb/WPR13LA002.md): Wood Mustang II FB · San Manuel, AZ · Accident · 1 fatal · Limited investigation · Final report · Oct 4, 2012 · N112MW · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.
- [NTSB WPR13FA001](https://openairdocs.org/ntsb/WPR13FA001.md): Piper PA-28-180 · Beatty, NV · Accident · Serious injuries · Field investigation · Final report · Oct 3, 2012 · N7895W · Substantial damage
  > The pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.
- [NTSB CEN13FA002](https://openairdocs.org/ntsb/CEN13FA002.md): Cirrus Design SR22 · Gary, IN · Accident · 2 fatal · Field investigation · Final report · Oct 3, 2012 · N308PJ · Substantial damage
  > The pilot's loss of control during an instrument approach due to spatial disorientation. Contributing to the accident were deficient approach control services and the pilot's loss of positional awareness.
- [NTSB WPR12LA441](https://openairdocs.org/ntsb/WPR12LA441.md): Team MINI-MAX · Chula Vista, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 2012 · N1532W · Substantial damage
  > A complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…
- [NTSB CEN12LA675](https://openairdocs.org/ntsb/CEN12LA675.md): Beech E33 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 26, 2012 · N7133N · Substantial damage
  > The loss of engine power for reasons that could not be determined during postaccident examinations and testing.
- [NTSB CEN12CA658](https://openairdocs.org/ntsb/CEN12CA658.md): Cessna 175A · Spearfish, SD · Accident · No injuries · Data collection · Final report · Sep 25, 2012 · N6979E · Substantial damage
  > The pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.
- [NTSB ERA12LA575](https://openairdocs.org/ntsb/ERA12LA575.md): Cessna 182Q · Fort Thomas, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2012 · N735FJ · Substantial damage
  > The pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.
- [NTSB WPR12FA432](https://openairdocs.org/ntsb/WPR12FA432.md): Kundel Vans RV 7A · Laramie, WY · Accident · 1 fatal · Field investigation · Final report · Sep 21, 2012 · N423RA · Destroyed
  > The pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.

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

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