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

## Latest cases

- [NTSB WPR14LA071](https://openairdocs.org/ntsb/WPR14LA071.md): Piper PA 32-301 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 18, 2013 · N8169C · Substantial damage
  > The total loss of engine power during takeoff due to fuel starvation, which resulted from the pilot’s failure to adequately manage the fuel supply.
- [NTSB CEN14CA088](https://openairdocs.org/ntsb/CEN14CA088.md): Piper PA 28R-200 · Bowling Green, OH · Accident · No injuries · Data collection · Final report · Dec 13, 2013 · N66CS · Substantial damage
  > A bird strike during takeoff.
- [NTSB WPR14CA066](https://openairdocs.org/ntsb/WPR14CA066.md): Mcdonnell Douglas Helicopter 369E · Monticello, UT · Accident · No injuries · Data collection · Final report · Dec 6, 2013 · N2066W · Substantial damage
  > The passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.
- [NTSB CEN14LA079](https://openairdocs.org/ntsb/CEN14LA079.md): Thompson William A Sparrow II · Jeromesville, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 4, 2013 · N5955Y · Substantial damage
  > The student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.
- [NTSB CEN14FA071](https://openairdocs.org/ntsb/CEN14FA071.md): Cessna 182E · Delta, CO · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2013 · N3087Y · Destroyed
  > The student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.
- [NTSB ENG14RA004](https://openairdocs.org/ntsb/ENG14RA004.md): Saab Saab 2000 · Lugano, Switzerland · Incident · No injuries · Foreign investigation · Nov 28, 2013 · HB-IZW
  > On November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…
- [NTSB ERA14FA049](https://openairdocs.org/ntsb/ERA14FA049.md): Piper PA-23-160 · Graniteville, SC · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2013 · N4016P · Substantial damage
  > The pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…
- [NTSB ERA14FA045](https://openairdocs.org/ntsb/ERA14FA045.md): Learjet 35 · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Nov 20, 2013 · XA-USD · Destroyed
  > The pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…
- [NTSB CEN14FA057](https://openairdocs.org/ntsb/CEN14FA057.md): Cessna 152 · Spring, TX · Accident · 2 fatal · Field investigation · Final report · Nov 18, 2013 · N555UF · Substantial damage
  > The flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.
- [NTSB ERA14LA043](https://openairdocs.org/ntsb/ERA14LA043.md): Maule M-5-180C · Marshfield, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2013 · N76RD · Destroyed
  > A partial loss of engine power for reasons that could not be determined in postaccident examinations because fire damage precluded testing of the fuel and several engine accessories.
- [NTSB CEN14LA054](https://openairdocs.org/ntsb/CEN14LA054.md): Quicksilver Mxii Sport · Erie, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 2013 · N2910P · Substantial damage
  > A loss of engine power due to a crankshaft failure, which resulted in a forced landing.
- [NTSB ERA14WA041](https://openairdocs.org/ntsb/ERA14WA041.md): Cirrus Design SR22 · Freeport, Bahamas · Accident · 4 fatal · Foreign investigation · Nov 10, 2013 · N432BC · Destroyed
- [NTSB ERA14LA011](https://openairdocs.org/ntsb/ERA14LA011.md): Boeing B75N1 · Tampa, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 19, 2013 · N65355 · No damage
  > The parachutist’s low altitude departure from the right wing before the planned altitude and his delayed opening of his parachute canopy, which resulted in impact with a tree and then the ground before the parachute fully opened.
- [NTSB WPR14CA019](https://openairdocs.org/ntsb/WPR14CA019.md): Robinson R44 - II · Sedro Woolley, WA · Accident · No injuries · Data collection · Final report · Oct 18, 2013 · N414CC · Substantial damage
  > The non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…
- [NTSB ANC14FA002](https://openairdocs.org/ntsb/ANC14FA002.md): Cessna 172C · Fairbanks, AK · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2013 · N1512Y · Substantial damage
  > The pilot’s failure to ensure that adequate fuel was on board the airplane, which resulted in fuel exhaustion and a subsequent collision with terrain.
- [NTSB WPR14CA009](https://openairdocs.org/ntsb/WPR14CA009.md): Beech A36 · Tilden, TX · Accident · Serious injuries · Data collection · Final report · Oct 6, 2013 · N2051N · Substantial damage
  > The pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.
- [NTSB WPR14WA098](https://openairdocs.org/ntsb/WPR14WA098.md): Amateur Built KR-2 · Tumut, New South Wales, Australia · Accident · 1 fatal · Foreign investigation · Oct 5, 2013 · VH-CTE · Destroyed
  > On October 5, 2013, at 0900 local time, an amateur built aircraft, KR-2, VH-CTE, collided with the terrain shortly after takeoff from a private airstrip near Tumut, New South Wales. The flight was operated by the pilot under the pertinent civil regulations of…
- [NTSB ERA14LA035](https://openairdocs.org/ntsb/ERA14LA035.md): Airborne Edge Executive · Eustis, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2013 · N927H · Substantial damage
  > The pilot's inadvertent stalling of the wing following a total loss of engine power for reasons that could not be determined during postaccident examinations, which resulted in a hard landing.
- [NTSB DCA14WA177](https://openairdocs.org/ntsb/DCA14WA177.md): Embraer EMB120 · Lagos, Nigeria · Accident · No injuries · Foreign investigation · Oct 3, 2013 · 5N-BJY · Destroyed
  > The Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving an Embraer120 airplane that occurred on October 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…
- [NTSB ERA13WA430](https://openairdocs.org/ntsb/ERA13WA430.md): Cessna R172K · Morona Santiago, Ecuador · Accident · 3 fatal · Foreign investigation · Sep 21, 2013 · HC-BGT · Destroyed
- [NTSB ERA13CA417](https://openairdocs.org/ntsb/ERA13CA417.md): Miller/Culpepper Christen Eagle II · Blythe, GA · Accident · Serious injuries · Data collection · Final report · Sep 14, 2013 · N887AS · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.
- [NTSB WPR13LA402](https://openairdocs.org/ntsb/WPR13LA402.md): Cessna 172N · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2013 · N42EP · Substantial damage
  > The total loss of engine power during initial climb due to debris within the carburetor mixture metering sleeve.
- [NTSB CEN13CA543](https://openairdocs.org/ntsb/CEN13CA543.md): Taylorcraft BL 65 · Chippewa Falls, WI · Accident · Serious injuries · Data collection · Final report · Sep 8, 2013 · N23683 · Substantial damage
  > The loss of engine power after takeoff due to carburetor icing.
- [NTSB ERA13LA406](https://openairdocs.org/ntsb/ERA13LA406.md): Engineering & Research 415-D · Beaver Falls, PA · Accident · No injuries · Limited investigation · Final report · Sep 6, 2013 · N3940H · Substantial damage
  > The owner/pilot’s failure to follow engine manufacturer recommendations for engine oil changes and spark plug cleaning and rotating when operating the airplane with 100 low lead fuel, which resulted in carbon buildup in the engine and the total loss of engine…
- [NTSB CEN13LA539](https://openairdocs.org/ntsb/CEN13LA539.md): Cessna T207 · Colorado Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2013 · N211AS · Substantial damage
  > The pilot’s failure to establish the proper pitch attitude and airspeed during takeoff with the engine at maximum power, which resulted in the exceedance of the airplane’s climb performance capability.
- [NTSB ERA13LA397](https://openairdocs.org/ntsb/ERA13LA397.md): Aeronca 65CA · Hardwick, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2013 · N31915 · Substantial damage
  > The improper maintenance of the carburetor, which resulted in a total loss of engine power due to carburetor flooding.
- [NTSB ERA13CA400](https://openairdocs.org/ntsb/ERA13CA400.md): Maxair Drifter Drifter II · Lafayette, TN · Accident · Minor injuries · Data collection · Final report · Sep 1, 2013 · N42548 · Substantial damage
  > The pilot's failure to maintain aircraft control during the initial climb after takeoff in gusty wind conditions, which resulted in a hard off-airport landing.
- [NTSB CEN13CA521](https://openairdocs.org/ntsb/CEN13CA521.md): Evektor-Aerotechnik Sportstar · Osage Beach, MO · Accident · No injuries · Data collection · Final report · Sep 1, 2013 · N407EV · Substantial damage
  > The pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.
- [NTSB ERA13LA382](https://openairdocs.org/ntsb/ERA13LA382.md): Consolidated Aeronautics Lake Model 250 · Middle Grove, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 2013 · N522WB · Substantial damage
  > Maintenance personnel’s application of insufficient torque to the No. 6 cylinder connecting rod bolts during overhaul, which resulted in the fatigue fracture of the connecting rod and a subsequent total loss of engine power.
- [NTSB CEN13FA509](https://openairdocs.org/ntsb/CEN13FA509.md): Cessna 421C · Paris, IL · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2013 · N229H · Destroyed
  > The pilot's failure to abort the takeoff during the ground roll after detecting the airplane's degraded performance. Contributing to the accident was the pilot's decision to attempt a flight with a known problem with the left engine and the likely partial…
- [NTSB ERA13LA380](https://openairdocs.org/ntsb/ERA13LA380.md): Piper PA46R-350T · Cat Cay, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2013 · N720JF · Substantial damage
  > The pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…
- [NTSB ERA13FA372](https://openairdocs.org/ntsb/ERA13FA372.md): Aeronca 7AC · Taunton, MA · Accident · 2 fatal · Field investigation · Final report · Aug 25, 2013 · N83863 · Destroyed
  > The pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…
- [NTSB DCA13WA144](https://openairdocs.org/ntsb/DCA13WA144.md): Airbus Industrie A300B4-622R · Luton, United Kingdom · Incident · No injuries · Foreign investigation · Aug 25, 2013 · N721FD · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A300 operated by Federal Express Corp, which occurred on August 25, 2013. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB WPR13LA384](https://openairdocs.org/ntsb/WPR13LA384.md): Piper PA 28 · Sacramento, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 2013 · N8223W · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined because postaccident examination revealed no evidence of preimpact mechanical malfunction or failure that would have precluded normal operation.
- [NTSB WPR13FA386](https://openairdocs.org/ntsb/WPR13FA386.md): Piper PA 28 · Tehachapi, CA · Accident · Serious injuries · Field investigation · Final report · Aug 24, 2013 · N32582 · Substantial damage
  > The pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.
- [NTSB CEN13LA502](https://openairdocs.org/ntsb/CEN13LA502.md): Anderas Tiger Moth R80 · New Franken, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2013 · N927TM · 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 ERA13LA370](https://openairdocs.org/ntsb/ERA13LA370.md): Beech C23 · Bingham, ME · Accident · No injuries · Limited investigation · Final report · Aug 20, 2013 · N243RG · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.
- [NTSB CEN13FA496](https://openairdocs.org/ntsb/CEN13FA496.md): Mooney M20J · Kansas City, MO · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2013 · N9201R · Substantial damage
  > The pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…
- [NTSB ERA13LA366](https://openairdocs.org/ntsb/ERA13LA366.md): Interstate S-1B1 · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Aug 17, 2013 · N46336 · Substantial damage
  > The pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…
- [NTSB ERA13CA354](https://openairdocs.org/ntsb/ERA13CA354.md): Stetson Norman B Challenger II · Orange, MA · Accident · No injuries · Data collection · Final report · Aug 6, 2013 · N94454 · Substantial damage
  > The pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.
- [NTSB ERA13CA350](https://openairdocs.org/ntsb/ERA13CA350.md): Cessna 172S · Portsmouth, NH · Accident · No injuries · Data collection · Final report · Aug 3, 2013 · N645PD · Substantial damage
  > The pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.
- [NTSB CEN13LA460](https://openairdocs.org/ntsb/CEN13LA460.md): Snyder Todd W Titan Tornado 1 · Wild Rose, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2013 · N70786 · Substantial damage
  > The improperly secured spark plug, which resulted in a total loss of engine power.
- [NTSB CEN13FA456](https://openairdocs.org/ntsb/CEN13FA456.md): Cirrus Design SR22 · Chesterfield, MO · Accident · 2 fatal · Field investigation · Final report · Aug 3, 2013 · N225CD · Destroyed
  > The pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.
- [NTSB ERA13LA346](https://openairdocs.org/ntsb/ERA13LA346.md): Fpna A-22 Valor · Wurtsboro, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 2013 · N912FP · Substantial damage
  > The pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.
- [NTSB WPR13LA347](https://openairdocs.org/ntsb/WPR13LA347.md): Airborne Windsports PTY Edge XT-912-L · Red Bluff, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 29, 2013 · N123FJ · Destroyed
  > The pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.
- [NTSB WPR13LA346](https://openairdocs.org/ntsb/WPR13LA346.md): Beech 35-B33 · Lone Pine, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2013 · N82182 · Substantial damage
  > A partial 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. Contributing to the accident was the pilot's decision to not…
- [NTSB CEN13LA455](https://openairdocs.org/ntsb/CEN13LA455.md): Piper PA-28-140 · Lafayette, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2013 · N286P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA13LA339](https://openairdocs.org/ntsb/ERA13LA339.md): Cessna 172M · Farmingdale, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2013 · N61929 · Substantial damage
  > The airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.
- [NTSB CEN13FA432](https://openairdocs.org/ntsb/CEN13FA432.md): Piper PA-30 · Amarillo, TX · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2013 · N8306Y · Substantial damage
  > The pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.
- [NTSB WPR13FA335](https://openairdocs.org/ntsb/WPR13FA335.md): Mooney M20C · South Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2013 · N6709U · Substantial damage
  > The pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.

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

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