# NTSB investigations, 2013: 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 6 · 280 cases

## Latest cases

- [NTSB CEN14WA208](https://openairdocs.org/ntsb/CEN14WA208.md): Cessna 525A · Honiley, United Kingdom · Accident · No injuries · Foreign investigation · Dec 31, 2013 · N380CR · Substantial damage
- [NTSB WPR14WA085](https://openairdocs.org/ntsb/WPR14WA085.md): Bell 206 · Berastagi, Indonesia · Accident · 1 fatal · Foreign investigation · Dec 30, 2013 · PK-DAL · Destroyed
  > On December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…
- [NTSB WPR14CA097](https://openairdocs.org/ntsb/WPR14CA097.md): Cameron Balloons US A-400 · Napa, CA · Accident · No injuries · Data collection · Final report · Dec 29, 2013 · N65298 · Substantial damage
  > Failure to maintain clearance from obstacles during a descent that resulted in an inadvertent collision with a pole.
- [NTSB CEN14CA095](https://openairdocs.org/ntsb/CEN14CA095.md): Cessna 182N · Paradis, LA · Accident · No injuries · Data collection · Final report · Dec 29, 2013 · N491CC · Substantial damage
  > The collision with a bird which resulted in substantial damage to the airplane.
- [NTSB WPR14LA079](https://openairdocs.org/ntsb/WPR14LA079.md): Stinson 108 1 · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2013 · N8848K · Substantial damage
  > The fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.
- [NTSB ERA14FA077](https://openairdocs.org/ntsb/ERA14FA077.md): Piper PA-30 · Biglerville, PA · Accident · 2 fatal · Field investigation · Final report · Dec 26, 2013 · N8372Y · Destroyed
  > The noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.
- [NTSB ERA14FA074](https://openairdocs.org/ntsb/ERA14FA074.md): Raytheon G36 · Panama City, FL · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2013 · N89SN · Substantial damage
  > The pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the pilot’s injuries was his failure to use the available shoulder harness.
- [NTSB WPR14CA069](https://openairdocs.org/ntsb/WPR14CA069.md): Cessna 150F · Henderson, NV · Accident · Minor injuries · Data collection · Final report · Dec 14, 2013 · N7015F · Substantial damage
  > The flight crew's improper in-flight fuel planning lead to fuel exhaustion, which resulted in a complete loss of engine power.
- [NTSB WPR14FA068](https://openairdocs.org/ntsb/WPR14FA068.md): Cessna 208B · Kalaupapa, HI · Accident · 1 fatal · Field investigation · Final report · Dec 12, 2013 · N687MA · Destroyed
  > The loss of engine power due to the fracture of multiple blades on the compressor turbine wheel, which resulted in a ditching. The reason for the blade failures could not be determined due to secondary thermal damage to the blades.
- [NTSB CEN14IA085](https://openairdocs.org/ntsb/CEN14IA085.md): Beech E90 · Eau Claire, WI · Incident · No injuries · Incident investigation · Final report · Dec 11, 2013 · N60BA · Minor damage
  > The failure of the copilot’s windshield inner layer due to a peel chip that developed as a result of mechanical and thermal expansion stresses.
- [NTSB CEN14LA081](https://openairdocs.org/ntsb/CEN14LA081.md): Rockwell International 112 · Hammond, LA · Accident · No injuries · Limited investigation · Final report · Dec 10, 2013 · N1203J · Substantial damage
  > The total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.
- [NTSB ERA14FA066](https://openairdocs.org/ntsb/ERA14FA066.md): Texas Helicopter M74L · Sebring, FL · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2013 · N1001N · Destroyed
  > A partial loss of engine power as a result of contamination of the engine’s fuel supply, and the pilot’s impaired performance due to his use of diphenhydramine, which resulted in his inability to complete a forced or precautionary autorotative landing…
- [NTSB WPR14LA061](https://openairdocs.org/ntsb/WPR14LA061.md): Piper PA 24-250 · Fair Oaks, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2013 · N6595P · Substantial damage
  > The loss of engine power during cruise flight for reasons that could not be determined because postaccident examinations of the airplane and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA14WA069](https://openairdocs.org/ntsb/ERA14WA069.md): Britten Norman BN2A - 2 · Novo Prgresso, Brazil · Accident · 5 fatal · Foreign investigation · Dec 4, 2013 · PT-WMY · Substantial damage
  > On December 4, 2013, about 1430 coordinated universal time (UTC), a Britten Norman Aircraft, model BN-2A, Brazilian registration PT-WMY, was substantially damaged when it impacted the ground shortly after takeoff from Novo Progresso Airport (SJNP), Novo…
- [NTSB ANC14CA010](https://openairdocs.org/ntsb/ANC14CA010.md): Bellanca 7GCBC · Soldotna, AK · Accident · Minor injuries · Data collection · Final report · Dec 4, 2013 · N88342 · Substantial damage
  > The operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…
- [NTSB ERA14MA060](https://openairdocs.org/ntsb/ERA14MA060.md): Fairchild SA227-AC · La Alianza, PR · Accident · 2 fatal · Major investigation · Final report · Dec 3, 2013 · N831BC · Destroyed
  > The flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…
- [NTSB ERA14FA058](https://openairdocs.org/ntsb/ERA14FA058.md): Piper PA-46-310P · Dawsonville, GA · Accident · 1 fatal · Field investigation · Final report · Dec 3, 2013 · N87NF · Destroyed
  > The pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…
- [NTSB ERA14CA062](https://openairdocs.org/ntsb/ERA14CA062.md): Anderson Andreas Rans S-6S · Traveler's Rest, SC · Accident · Minor injuries · Data collection · Final report · Dec 3, 2013 · N581TC · Substantial damage
  > The pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.
- [NTSB CEN14LA075](https://openairdocs.org/ntsb/CEN14LA075.md): Cessna 560 · Walton, IN · Accident · No injuries · Limited investigation · Final report · Dec 2, 2013 · N810QS · Substantial damage
  > The inflight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.
- [NTSB WPR14FA094](https://openairdocs.org/ntsb/WPR14FA094.md): Beech B36TC · Yellow Pine, ID · Accident · 5 fatal · Field investigation · Final report · Dec 1, 2013 · N36ML · Destroyed
  > The pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.
- [NTSB CEN14LA074](https://openairdocs.org/ntsb/CEN14LA074.md): Piper PA 28-181 · Rock Lake, ND · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2013 · N6780F · Substantial damage
  > The noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…
- [NTSB DCA14RA018](https://openairdocs.org/ntsb/DCA14RA018.md): Embraer ERJ190 - Undesignat · Rundu, Namibia · Accident · 33 fatal · Foreign investigation · Nov 30, 2013 · 9C-EMC · Destroyed
  > The Namibia Ministry of Works and Transport (MWT) has notified the NTSB of an accident involving an Embraer ERJ-190 that occurred on November 30, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the MWT investigation under the…
- [NTSB ERA14LA051](https://openairdocs.org/ntsb/ERA14LA051.md): Cessna 210L · Montrose, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 2013 · N777BK · Substantial damage
  > The pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.
- [NTSB ERA14LA048](https://openairdocs.org/ntsb/ERA14LA048.md): Cessna 150L · Hopewell, AL · Accident · No injuries · Limited investigation · Final report · Nov 25, 2013 · N16078 · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.
- [NTSB DCA14CA031](https://openairdocs.org/ntsb/DCA14CA031.md): De Havilland DHC8 - 102 · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Nov 25, 2013 · N808EX · Substantial damage
  > an inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.
- [NTSB CEN14FA064](https://openairdocs.org/ntsb/CEN14FA064.md): Cessna T210 · Cedaredge, CO · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2013 · N6832B · Destroyed
  > The pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…
- [NTSB CEN14WA067](https://openairdocs.org/ntsb/CEN14WA067.md): Robinson R44 - II · Neuhausen ob Eck, Germany · Accident · 2 fatal · Foreign investigation · Nov 19, 2013 · D-HOMI · Substantial damage
  > On November 19, 2013, at 1134 coordinated universal time, a Robinson R44 II, Germany-registered D-HOMI, was substantially damaged when it impacted forested terrain near Neuhausen ob Eck, Germany. Instrument meteorological conditions prevailed at the time of…
- [NTSB CEN14WA062](https://openairdocs.org/ntsb/CEN14WA062.md): Socata TBM 700 · Mouffy, France · Accident · 6 fatal · Foreign investigation · Nov 19, 2013 · N115KC · Destroyed
- [NTSB WPR14LA056](https://openairdocs.org/ntsb/WPR14LA056.md): Cessna T210 - F · Oceanside, CA · Accident · No injuries · Limited investigation · Final report · Nov 17, 2013 · N6186R · Substantial damage
  > The pilot's failure to determine the actual onboard fuel quantity before beginning the flight, which resulted in a complete loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's habitual reliance solely on the cockpit fuel…
- [NTSB WPR14LA055](https://openairdocs.org/ntsb/WPR14LA055.md): Richard S Duncan Avid Flyer · Lakeside, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2013 · N1445P · Substantial damage
  > The pilot/owner’s failure to comply with the engine manufacturer’s maintenance guidance, which resulted in the total loss of engine power due to the fracture failure of the plastic drive gear for the engine lubricating oil pump.
- [NTSB ANC14WA006](https://openairdocs.org/ntsb/ANC14WA006.md): Sikorsky S76-C++ · Seoul, South Korea · Accident · 2 fatal · Foreign investigation · Nov 16, 2013 · HL9294 · Substantial damage
  > On November 16, 2013, about 2354 Coordinated Universal Time, a Sikorsky S76 C++ helicopter, Korean registration HL9294, operated by LG Electronics Co. Ltd., sustained substantial damage after colliding with a 26-story apartment building in Seoul, Korea. Both…
- [NTSB CEN14FA051](https://openairdocs.org/ntsb/CEN14FA051.md): Cessna T310R · Junction, TX · Accident · 2 fatal · Field investigation · Final report · Nov 12, 2013 · N38LH · Destroyed
  > The noninstrument-rated private pilot's decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in the loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a weather…
- [NTSB ERA14LA042](https://openairdocs.org/ntsb/ERA14LA042.md): Piper PA28 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2013 · N1830T · Substantial damage
  > A total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.
- [NTSB ERA14WA063](https://openairdocs.org/ntsb/ERA14WA063.md): Piper PA-34-220T · Parati, Brazil, Brazil · Accident · 3 fatal · Foreign investigation · Nov 10, 2013 · PR-EAG · Destroyed
  > On November 10, 2013 about 1600 universal coordinated time, a Piper PA-34-220T, Brazilian registration PR-EAG, was destroyed when it collided during a climb with the peak of Corisco Mountain, located in the Serra do Mar mountain range, near Parati…
- [NTSB DCA14WA070](https://openairdocs.org/ntsb/DCA14WA070.md): Boeing 737 · Seville Airport, Spain · Incident · No injuries · Foreign investigation · Nov 8, 2013 · EI-DPF · No damage
  > The government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 08, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB WPR14LA046](https://openairdocs.org/ntsb/WPR14LA046.md): Rovey Jason H RV-8 · Wickenburg, AZ · Accident · No injuries · Limited investigation · Final report · Nov 2, 2013 · N391V · Substantial damage
  > The fatigue failure of a propeller pitch change pin due to excessive shot peening of the pin’s surface during the manufacturing process.
- [NTSB CEN14LA036](https://openairdocs.org/ntsb/CEN14LA036.md): Cessna 182L · Superior, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2013 · N70520 · 2 aircraft · Destroyed
  > The failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.
- [NTSB ERA14LA034](https://openairdocs.org/ntsb/ERA14LA034.md): Teal Harry H Sonerai II Stretch · De Leon Springs, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2013 · N1927B · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of preexisting mechanical anomalies or failures that would have precluded normal operation.
- [NTSB DCA14WA008](https://openairdocs.org/ntsb/DCA14WA008.md): Robinson R22 - Undesignat · Herolds Bay, South Africa · Accident · No injuries · Foreign investigation · Oct 29, 2013 · ZS-RTV · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on October 29, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB CEN14FA032](https://openairdocs.org/ntsb/CEN14FA032.md): Glasair Aviation USA Sportsman GS-2 · Castle Rock, CO · Accident · Serious injuries · Field investigation · Final report · Oct 29, 2013 · N535SP · Substantial damage
  > The pilot’s improper decision to continue flight into known icing conditions, which adversely affected the airplane’s performance and resulted in a loss of airplane control.
- [NTSB WPR14CA052](https://openairdocs.org/ntsb/WPR14CA052.md): Bell 206B · Milo, OR · Accident · Serious injuries · Data collection · Final report · Oct 28, 2013 · N16673 · Substantial damage
  > The pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.
- [NTSB WPR14LA036](https://openairdocs.org/ntsb/WPR14LA036.md): Cessna T210M · Scipio, UT · Accident · No injuries · Limited investigation · Final report · Oct 27, 2013 · N761BP · Substantial damage
  > A total loss of engine power 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 ERA14LA094](https://openairdocs.org/ntsb/ERA14LA094.md): Cessna 150H · Livingston, AL · Accident · No injuries · Limited investigation · Final report · Oct 26, 2013 · N684RA · Substantial damage
  > The pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…
- [NTSB CEN14LA031](https://openairdocs.org/ntsb/CEN14LA031.md): Cessna T210L · Borger, TX · Accident · No injuries · Limited investigation · Final report · Oct 25, 2013 · N398MA · Substantial damage
  > The failure of the No. 4 connecting rod due to inadequate oil lubrication.
- [NTSB WPR14LA031](https://openairdocs.org/ntsb/WPR14LA031.md): Piper PA 28-180 · Big Creek, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2013 · N30865 · Substantial damage
  > The loss of engine power due to the improper installation of an oil pressure sending unit by the pilot, who was not a certificated mechanic, which resulted in a forced landing in mountainous terrain.
- [NTSB CEN14LA015](https://openairdocs.org/ntsb/CEN14LA015.md): North American P 51D · Galveston, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 23, 2013 · N4151D · Substantial damage
  > The pilot's loss of situational awareness while instructing the passenger, which resulted in the controlled flight of the airplane into the water.
- [NTSB WPR14FA024](https://openairdocs.org/ntsb/WPR14FA024.md): Cessna 208 · Wailea, HI · Accident · No injuries · Field investigation · Final report · Oct 22, 2013 · N861MA · Substantial damage
  > Improper maintenance that resulted in contamination of the engine's compressor turbine disc and blade assembly by glass bead remnants, which resulted in a blade failure.
- [NTSB DCA14WA005](https://openairdocs.org/ntsb/DCA14WA005.md): Boeing 757 223 · Providenciales, Turks & Caicos Islands · Incident · No injuries · Foreign investigation · Oct 22, 2013 · N605AA · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB WPR14LA023](https://openairdocs.org/ntsb/WPR14LA023.md): Cessna 172 - M · Hardin, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2013 · N80257 · Substantial damage
  > A rough-running engine and partial loss of power, which resulted from the pilot’s failure to use carburetor heat appropriately while operating in an area conducive to carburetor icing.
- [NTSB ERA14CA009](https://openairdocs.org/ntsb/ERA14CA009.md): Eurocopter AS 350 B2 · Madison, MS · Accident · Minor injuries · Data collection · Final report · Oct 20, 2013 · N911ES · Substantial damage
  > The helicopter's collision with a black vulture during climb to cruise altitude.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2013&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") = 2013
  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=2013

---
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.