# NTSB investigations: 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 83 of 718 · 35,885 cases

## Cases, newest first

- [NTSB WPR13LA383](https://openairdocs.org/ntsb/WPR13LA383.md): Piper PA-38 · Madera, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 2013 · N2578L · Substantial damage
  > The pilots' inadequate fuel planning, which resulted in the airplane departing with insufficient fuel to complete the planned flight, and their failure to recognize that discrepancy en route, which resulted in a total loss of engine power due to fuel…
- [NTSB WPR13CA381](https://openairdocs.org/ntsb/WPR13CA381.md): Cessna 172E · Meeteetse, WY · Accident · Minor injuries · Data collection · Final report · Aug 20, 2013 · N516MA · Substantial damage
  > The student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.
- [NTSB WPR13LA378](https://openairdocs.org/ntsb/WPR13LA378.md): Cessna 172B · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Aug 18, 2013 · N8141X · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because the engine was not properly preserved to prevent corrosion after the wreckage was recovered from the lake.
- [NTSB ERA13WA367](https://openairdocs.org/ntsb/ERA13WA367.md): Cessna 172 · Bolzano, Italy · Accident · 4 fatal · Foreign investigation · Aug 17, 2013 · D-EDQL · Destroyed
  > On August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…
- [NTSB ERA13LA364](https://openairdocs.org/ntsb/ERA13LA364.md): Piper PA-22-150 · Indian Trail, NC · Accident · No injuries · Limited investigation · Final report · Aug 16, 2013 · N6919B · Substantial damage
  > The pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN13LA500](https://openairdocs.org/ntsb/CEN13LA500.md): Cessna 206 · Brooklyn, IA · Accident · 1 fatal · Limited investigation · Final report · Aug 16, 2013 · N2070K · Minor damage
  > The improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.
- [NTSB DCA13WA157](https://openairdocs.org/ntsb/DCA13WA157.md): Boeing 777 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Aug 15, 2013 · VH-VPF · No damage
  > The Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 777 that occurred on August 15, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…
- [NTSB CEN13LA490](https://openairdocs.org/ntsb/CEN13LA490.md): Taylorcraft BC12-D1 · Eastport, MI · Accident · No injuries · Limited investigation · Final report · Aug 14, 2013 · N44351 · Destroyed
  > A fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.
- [NTSB CEN13LA519](https://openairdocs.org/ntsb/CEN13LA519.md): Gulfstream-Schweizer Gulfstream AM G 164B · Eagle Lake, TX · Accident · No injuries · Limited investigation · Final report · Aug 13, 2013 · N8222K · Substantial damage
  > The failure of one of the engine cylinders, which resulted in the total loss of engine power and subsequent forced landing.
- [NTSB CEN13FA491](https://openairdocs.org/ntsb/CEN13FA491.md): Bell 407 · Ship Shoal 208H (Gulf of Mexico) · Accident · Minor injuries · Field investigation · Final report · Aug 13, 2013 · N53LP · Substantial damage
  > The ingestion of vented methane gas into the helicopter’s engine during takeoff, which caused an engine compressor surge that led to a total loss of engine power.
- [NTSB ANC13LA079](https://openairdocs.org/ntsb/ANC13LA079.md): Piper PA-18-150 · Paxson, AK · Accident · No injuries · Limited investigation · Final report · Aug 13, 2013 · N44RT · Substantial damage
  > The partial loss of engine power due to a loose throttle cable clamp.
- [NTSB ERA13CA362](https://openairdocs.org/ntsb/ERA13CA362.md): Piper PA-28R-180 · Fredericksburg, VA · Accident · No injuries · Data collection · Final report · Aug 12, 2013 · N4969J · Substantial damage
  > The pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…
- [NTSB CEN13FA476](https://openairdocs.org/ntsb/CEN13FA476.md): Beechcraft F33A · Ennis, TX · Accident · 2 fatal · Field investigation · Final report · Aug 11, 2013 · N4514S · Substantial damage
  > The loss of engine power for reasons that could not be determined during postaccident examinations due to postcrash fire damage.
- [NTSB CEN13WA576](https://openairdocs.org/ntsb/CEN13WA576.md): Socata TB10 - NO Series · Zamora, Spain · Accident · No injuries · Foreign investigation · Aug 9, 2013 · EC-FPN · Substantial damage
  > On August 9, 2013, about 0930 UTC, a Socata TB-10 airplane, EC-FPN, (s/n 1485) was involved in a forced landing following an engine failure. The airplane was substantially damaged and there were no injuries. This investigation is under the jurisdiction and…
- [NTSB ANC13TA076](https://openairdocs.org/ntsb/ANC13TA076.md): Bell UH-1B · Tok, AK · Accident · No injuries · Final report · Aug 8, 2013 · N70NW · Substantial damage
  > The failure of the tail rotor crosshead bearing, which resulted in a loss of tail rotor control.
- [NTSB ERA13WA359](https://openairdocs.org/ntsb/ERA13WA359.md): Robinson R-44 · Davidovo, Russia · Accident · 2 fatal · Foreign investigation · Aug 6, 2013 · RA-06302 · Destroyed
  > On August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…
- [NTSB CEN13FA465](https://openairdocs.org/ntsb/CEN13FA465.md): Air Tractor AT-400 · Balko, OK · Accident · 1 fatal · Field investigation · Final report · Aug 5, 2013 · N3159B · Destroyed
  > The pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.
- [NTSB DCA13WA169](https://openairdocs.org/ntsb/DCA13WA169.md): Boeing 737 - 377 · Leeds, United Kingdom · Incident · No injuries · Foreign investigation · Aug 2, 2013 · G-CELF · No damage
  > The United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on August 02, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…
- [NTSB WPR13LA353](https://openairdocs.org/ntsb/WPR13LA353.md): Weber GPA-2 · Brentwood, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 2013 · N199BW · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB DCA13WA134](https://openairdocs.org/ntsb/DCA13WA134.md): Boeing 737 · Batopilas, Mexico · Accident · Serious injuries · Class 5 · Foreign · Jul 31, 2013 · N173AT · No damage
- [NTSB ERA13TA341](https://openairdocs.org/ntsb/ERA13TA341.md): Mcdonnell Douglas Helicopter 369E · Jackson, KY · Accident · Serious injuries · Final report · Jul 29, 2013 · N1608D · Destroyed
  > The helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.
- [NTSB CEN13LA443](https://openairdocs.org/ntsb/CEN13LA443.md): Grumman G-164A · Monte Vista, CO · Accident · No injuries · Limited investigation · Final report · Jul 29, 2013 · N5324 · Substantial damage
  > The partial loss of engine power due to a fatigue failure of the engine cylinder exhaust rocker housing as a result of an excessively torqued rocker assembly.
- [NTSB ERA13FA336](https://openairdocs.org/ntsb/ERA13FA336.md): Robinson R66 · Noxen, PA · Accident · 5 fatal · Field investigation · Final report · Jul 28, 2013 · N646AG · Destroyed
  > The pilot's decision to continue VFR flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB CEN13FA440](https://openairdocs.org/ntsb/CEN13FA440.md): Phelps Kitfox III · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Jul 28, 2013 · N873RX · Substantial damage
  > The degraded fuel line, which prevented fuel from the left tank from reaching the header tank and resulted in the loss of engine power due to fuel starvation.
- [NTSB CEN13FA438](https://openairdocs.org/ntsb/CEN13FA438.md): Piper PA-28R-200 · Lake Michigan, WI · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2013 · N1549X · Destroyed
  > An encounter with wake turbulence, which resulted in the pilot’s loss of control of the airplane and its subsequent in-flight breakup. Contributing to the accident was the approach controller’s failure to issue a wake turbulence advisory to the pilot.
- [NTSB ANC13LA068](https://openairdocs.org/ntsb/ANC13LA068.md): Dehavilland Beaver DHC 2 · Thorne Bay, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2013 · N4787C · Substantial damage
  > The failure of the No. 1 linkrod bushing or the bottom portion of the linkrod, which resulted in a total loss of engine power.
- [NTSB CEN13WA577](https://openairdocs.org/ntsb/CEN13WA577.md): Cessna Cessna 525B · Paris, France · Incident · No injuries · Foreign investigation · Jul 22, 2013 · F-HCIC · Minor damage
  > On July 22, 2013, at 0610 UTC, a Cessna 525B Citation CJ3, French registration F-HCIC, experienced smoke in the cabin and cockpit while passing FL 140 during an enroute climb southeast of Paris, France. The number one engine was shut down, the crew declared…
- [NTSB ERA13LA328](https://openairdocs.org/ntsb/ERA13LA328.md): Cirrus Design SR22 · Tappahannock, VA · Accident · No injuries · Limited investigation · Final report · Jul 21, 2013 · N223SS · Substantial damage
  > A failure of the engine crankshaft top rear trailing forward counterweight retaining plate, which resulted in a total loss of engine power. The reason for the retaining plate’s failure could not be determined during postaccident examination.
- [NTSB ENG13WA039](https://openairdocs.org/ntsb/ENG13WA039.md): Boeing 777 - 340ER · Moscow, Russia · Incident · No injuries · Foreign investigation · Jul 21, 2013 · AP-BHV · No damage
  > The Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…
- [NTSB CEN13LA428](https://openairdocs.org/ntsb/CEN13LA428.md): Cooper, David W. Challenger II · Mill Creek, IN · Accident · 1 fatal · Limited investigation · Final report · Jul 21, 2013 · N1519 · Destroyed
  > The noncertificated pilot's improper fuel planning, which led to fuel exhaustion and a loss of engine power. Contributing to the accident was the pilot's failure to obtain adequate instruction or an endorsement to solo in the accident airplane model, which…
- [NTSB ERA13WA356](https://openairdocs.org/ntsb/ERA13WA356.md): Beech G36 · Bonito, Brazil · Accident · 2 fatal · Foreign investigation · Jul 19, 2013 · PR- KEX · Destroyed
  > On July 19, 2013, about 1330 universal coordinated time (UTC), a Hawker Beechcraft G16, Brazilian registration PR-KEX, registered to a private owner and operated by a private individual, impacted terrain during flight in the vicinity of the Bonito…
- [NTSB DCA14WA108](https://openairdocs.org/ntsb/DCA14WA108.md): Boeing 737-800 · Perugia, Italy · Accident · Serious injuries · Foreign investigation · Jul 18, 2013 · EI-DWF · No damage
  > The Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an accident involving a Boeing 737-800 that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…
- [NTSB ERA13LA327](https://openairdocs.org/ntsb/ERA13LA327.md): Univair 108-1 · Tuftonboro, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2013 · N8721K · Substantial damage
  > Maintenance personnel’s failure to remove circumferential gouges in the aft radius of the R2 rod journal on the crankshaft during its last engine overhaul, which resulted in the fatigue failure of the crankshaft and a subsequent total loss of engine power.
- [NTSB CEN13LA417](https://openairdocs.org/ntsb/CEN13LA417.md): Piper PA-22-125 · Mapleton, MN · Accident · No injuries · Limited investigation · Final report · Jul 16, 2013 · N663A · Substantial damage
  > The total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing to unsuitable terrain.
- [NTSB WPR13LA363](https://openairdocs.org/ntsb/WPR13LA363.md): Quarnoccio Avid Flyer · White City, OR · Accident · No injuries · Limited investigation · Final report · Jul 13, 2013 · N399Q · Substantial damage
  > Excessive engine operating temperature, which resulted in engine failure and a forced landing. The reason for the excessive engine operating temperature could not be determined during postaccident engine examination.
- [NTSB DCA13CA128](https://openairdocs.org/ntsb/DCA13CA128.md): Boeing 777-232 · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · Jul 12, 2013 · N863DA · No damage
  > Unexpected encounter with convective turbulence while the flight attendants were preparing the cabin for arrival.
- [NTSB ERA13WA319](https://openairdocs.org/ntsb/ERA13WA319.md): Diamond DA40-180 · Ticlio, Peru · Accident · 2 fatal · Foreign investigation · Jul 11, 2013 · N293DS · Destroyed
- [NTSB WPR13LA320](https://openairdocs.org/ntsb/WPR13LA320.md): Stinson 108-3 · Blackfoot, ID · Accident · No injuries · Limited investigation · Final report · Jul 10, 2013 · N703C · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR13LA317](https://openairdocs.org/ntsb/WPR13LA317.md): Cessna 182H · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2013 · N2062X · Substantial damage
  > The loss of engine power during cruise flight due to the detachment of the mixture control cable from its mounting clamp.
- [NTSB WPR13LA315](https://openairdocs.org/ntsb/WPR13LA315.md): Robinson Helicopter R22 · Alta, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2013 · N712U · Destroyed
  > The flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.
- [NTSB CEN13LA398](https://openairdocs.org/ntsb/CEN13LA398.md): Flight Design Ctls · Sandwich, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2013 · N549LS · Substantial damage
  > The pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.
- [NTSB ANC13CA062](https://openairdocs.org/ntsb/ANC13CA062.md): Aeronca 11AC · Kodiak, AK · Accident · No injuries · Data collection · Final report · Jul 6, 2013 · N9118E · Substantial damage
  > The loss of engine power due to carburetor icing and the pilot's failure to continue the use of carburetor heat after experiencing carburetor ice.
- [NTSB CEN13LA397](https://openairdocs.org/ntsb/CEN13LA397.md): Piper PA 46-350P · Nappanee, IN · Accident · No injuries · Limited investigation · Final report · Jul 5, 2013 · N502EU · Substantial damage
  > The failure of the No. 6 piston due to detonation and the subsequent interruption of the engine oil flow that resulted from the piston fragments.
- [NTSB WPR13LA304](https://openairdocs.org/ntsb/WPR13LA304.md): Dorman Bakeng · Garden Valley, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 2013 · N39796 · Substantial damage
  > A mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.
- [NTSB ENG13IA033](https://openairdocs.org/ntsb/ENG13IA033.md): Boeing 777 · Ugolny Airport, Russia · Incident · No injuries · Incident investigation · Final report · Jul 2, 2013 · HL8275 · No damage
  > The failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…
- [NTSB WPR13LA302](https://openairdocs.org/ntsb/WPR13LA302.md): S.N.I.A.S. AS-350B Ecureuil · Hamilton, MT · Accident · No injuries · Limited investigation · Final report · Jul 1, 2013 · N989WC · Substantial damage
  > The loss of engine power during cruise flight due to the fatigue failure of a pneumatic fuel controller pipe. Also causal was maintenance personnel’s failure to adequately maintain the pipe and replace it with a thicker type.
- [NTSB ANC13CA060](https://openairdocs.org/ntsb/ANC13CA060.md): Piper PA-12 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Jul 1, 2013 · N3885M · Substantial damage
  > The pilot's loss of situational awareness, which resulted in a wrong turn into a box canyon, and an in flight collision with terrain.
- [NTSB ERA13IA313](https://openairdocs.org/ntsb/ERA13IA313.md): Bell Helicopter Textron Canada 206 · New York, NY · Incident · No injuries · Incident investigation · Final report · Jun 30, 2013 · N405MR · Minor damage
  > The improper maintenance decision to adjust the engine oil pressure regulator valve in response to high oil pressure indications rather than to properly troubleshoot the anomaly, which then allowed an existing oil supply path blockage to increase and led to…
- [NTSB CEN13LA396](https://openairdocs.org/ntsb/CEN13LA396.md): Bell 47D1 · Lake Ozark, MO · Accident · No injuries · Limited investigation · Final report · Jun 28, 2013 · N78900 · Substantial damage
  > The improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.
- [NTSB CEN13LA388](https://openairdocs.org/ntsb/CEN13LA388.md): Mooney M20K · Hudson, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2013 · N5254G · Substantial damage
  > The pilot's improper fuel management, which resulted in the loss of engine power due to fuel starvation.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=84

## 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 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?page=83

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