# 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 71 of 718 · 35,883 cases

## Cases, newest first

- [NTSB WPR16FA006](https://openairdocs.org/ntsb/WPR16FA006.md): Cessna 182 · Hope, ID · Accident · 3 fatal · Field investigation · Final report · Oct 8, 2015 · N6184F · Destroyed
  > The pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.
- [NTSB CEN16LA032](https://openairdocs.org/ntsb/CEN16LA032.md): Cessna 177RG · Red Oak, IA · Accident · No injuries · Limited investigation · Final report · Oct 8, 2015 · N1542H · Substantial damage
  > The improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.
- [NTSB GAA16CA020](https://openairdocs.org/ntsb/GAA16CA020.md): Beech A36 · Jasper, TX · Accident · No injuries · Data collection · Final report · Oct 6, 2015 · N4151Q · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.
- [NTSB ERA16WA025](https://openairdocs.org/ntsb/ERA16WA025.md): Piper PA-28R-200 · Brazil, Brazil · Accident · 2 fatal · Foreign investigation · Oct 6, 2015 · PT-NKU · Destroyed
  > On October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…
- [NTSB CEN16LA012](https://openairdocs.org/ntsb/CEN16LA012.md): Refling RV8 · Bottineau, ND · Accident · No injuries · Limited investigation · Final report · Oct 6, 2015 · UNREG · Substantial damage
  > The pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB CEN16FA005](https://openairdocs.org/ntsb/CEN16FA005.md): Beech P35 · Chadron, NE · Accident · 1 fatal · Field investigation · Final report · Oct 6, 2015 · N877DM · Destroyed
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.
- [NTSB ENG16IA001](https://openairdocs.org/ntsb/ENG16IA001.md): Boeing 747 · Russian airspace, Japan · Incident · No injuries · Incident investigation · Final report · Oct 2, 2015 · N662US · Minor damage
  > The PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…
- [NTSB CEN16FA001](https://openairdocs.org/ntsb/CEN16FA001.md): Piper PA 28-140 · Huntsville, TX · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2015 · N3552K · Substantial damage
  > The pilot's mismanagement off the fuel supply to the engine, which resulted in fuel starvation.
- [NTSB DCA16CA001](https://openairdocs.org/ntsb/DCA16CA001.md): Airbus A319 · Nassau, Bahamas · Accident · Serious injuries · Data collection · Final report · Oct 1, 2015 · N9026C · No damage
  > an inadvertent encounter with convective turbulence.
- [NTSB ERA15LA377](https://openairdocs.org/ntsb/ERA15LA377.md): Piper PA 28RT-201T · Dawson Springs, KY · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2015 · N2175K · Substantial damage
  > The fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.
- [NTSB CEN15LA432](https://openairdocs.org/ntsb/CEN15LA432.md): Rans S18 · Shattuck, OK · Accident · 1 fatal · Limited investigation · Final report · Sep 29, 2015 · UNREG · Substantial damage
  > The noncertificated pilot’s failure to maintain control of the unregistered airplane during initial climb and his subsequent exceedance of the airplane’s critical angle-of-attack, which resulted in a stall/spin.
- [NTSB CEN15LA430](https://openairdocs.org/ntsb/CEN15LA430.md): Cessna 182G · Glenwood Springs, CO · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2015 · N3147S · Substantial damage
  > A loss of engine power during cruise flight due to carburetor icing and the pilot's failure to apply carburetor heat, which resulted in a forced landing on rough/uneven terrain.
- [NTSB CEN15WA429](https://openairdocs.org/ntsb/CEN15WA429.md): Piper PA28 · Sandstedt, Germany · Accident · 4 fatal · Foreign investigation · Sep 26, 2015 · D-EBVM · 2 aircraft · Destroyed
  > On September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…
- [NTSB CEN15LA433](https://openairdocs.org/ntsb/CEN15LA433.md): Cessna 150F · Fort Wayne, IN · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 2015 · N6922F · Substantial damage
  > The pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15WA370](https://openairdocs.org/ntsb/ERA15WA370.md): Bell 206 · Maceio, Brazil · Accident · 4 fatal · Foreign investigation · Sep 23, 2015 · PP-ELA · Destroyed
  > On September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…
- [NTSB CEN15LA421](https://openairdocs.org/ntsb/CEN15LA421.md): Lerch RV6A · Deckerville, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2015 · N215DG · Substantial damage
  > The in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.
- [NTSB CEN15WA456](https://openairdocs.org/ntsb/CEN15WA456.md): Amateur Construction Glasair RG · Muhen, Switzerland · Accident · 1 fatal · Foreign investigation · Sep 20, 2015 · HB-YEA · Destroyed
  > On September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…
- [NTSB ERA15LA368](https://openairdocs.org/ntsb/ERA15LA368.md): Cessna 150M · Mount Airy, MD · Accident · No injuries · Limited investigation · Final report · Sep 19, 2015 · N714CW · Substantial damage
  > The in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.
- [NTSB CEN15LA416](https://openairdocs.org/ntsb/CEN15LA416.md): Cessna R172 · College Station, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2015 · N180CM · Substantial damage
  > The total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.
- [NTSB DCA15WA197](https://openairdocs.org/ntsb/DCA15WA197.md): Boeing 737 · Frankfort, Germany · Incident · No injuries · Foreign investigation · Sep 14, 2015 · EI-EKC · No damage
  > The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…
- [NTSB GAA15CA261](https://openairdocs.org/ntsb/GAA15CA261.md): Piper PA 28-181 · Lexington, NE · Accident · No injuries · Data collection · Final report · Sep 13, 2015 · N121LK · Substantial damage
  > The pilot's improper fuel planning which resulted in fuel exhaustion, and loss of engine power. Additionally, the pilot's failure to maintain pitch control during the emergency landing, which resulted in an aerodynamic stall.
- [NTSB DCA15WA203](https://openairdocs.org/ntsb/DCA15WA203.md): Airbus A320 · Perth, Australia · Incident · No injuries · Foreign investigation · Sep 12, 2015 · VH-FNP · No damage
  > The Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…
- [NTSB ERA15FA351](https://openairdocs.org/ntsb/ERA15FA351.md): Cessna 172 · Riegelwood, NC · Accident · 1 fatal · Field investigation · Final report · Sep 11, 2015 · N52445 · Substantial damage
  > The noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.
- [NTSB CEN15LA407](https://openairdocs.org/ntsb/CEN15LA407.md): Alon A2 · Laramie, WY · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 2015 · N6359V · Substantial damage
  > The pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…
- [NTSB ERA15LA349](https://openairdocs.org/ntsb/ERA15LA349.md): Mooney M20TN · Atlantic City (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Sep 10, 2015 · N370MM · Substantial damage
  > A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…
- [NTSB CEN15WA454](https://openairdocs.org/ntsb/CEN15WA454.md): Robinson R44 · Foleyet, Canada · Accident · 2 fatal · Foreign investigation · Sep 9, 2015 · C-GZFX
  > On September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…
- [NTSB ERA15LA345](https://openairdocs.org/ntsb/ERA15LA345.md): Piper PA 28R-201T · Atmore, AL · Accident · No injuries · Limited investigation · Final report · Sep 7, 2015 · N44903 · Substantial damage
  > A total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.
- [NTSB DCA15WA188](https://openairdocs.org/ntsb/DCA15WA188.md): Boeing 737 · Tambacounda, Senegal · Accident · 7 fatal · Foreign investigation · Sep 5, 2015 · 3C-LLY · 2 aircraft · Minor damage
- [NTSB CEN15FA400](https://openairdocs.org/ntsb/CEN15FA400.md): Cessna 310H · Silverton, CO · Accident · 4 fatal · Field investigation · Final report · Sep 5, 2015 · N1099Q · Destroyed
  > The noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.
- [NTSB ERA15LA338](https://openairdocs.org/ntsb/ERA15LA338.md): Cessna R172 · Cresskill, NJ · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2015 · N758DK · Destroyed
  > Maintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts during installation of the engine cylinders, which resulted in the loosening of the components, loss of lubrication, failure of the crankshaft, and the…
- [NTSB ERA15FA336](https://openairdocs.org/ntsb/ERA15FA336.md): Henderson W A/Johnson W L RV 6A · Bon Aqua, TN · Accident · 1 fatal · Field investigation · Final report · Sep 2, 2015 · N216LA · Substantial damage
  > The pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.
- [NTSB WPR15LA254](https://openairdocs.org/ntsb/WPR15LA254.md): Raudenbush Ernie Lancair Super ES · Winkelman, AZ · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2015 · N74ES · Destroyed
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.
- [NTSB ERA15WA371](https://openairdocs.org/ntsb/ERA15WA371.md): Embraer EMB721 · Sao Felix do Xingu, Brazil · Accident · 2 fatal · Foreign investigation · Aug 30, 2015 · PT-EPD · Substantial damage
  > On August 30, 2015, about 1830 universal coordinated time, an Embraer EMB721, Brazilian registration PT-EPD, was substantially damaged during a forced landing after a loss of engine power near São Félix do Xingu Municipality, State of Pará, Brazil. The…
- [NTSB ERA15LA333](https://openairdocs.org/ntsb/ERA15LA333.md): Beech E 90 · Fayetteville, TN · Accident · No injuries · Limited investigation · Final report · Aug 28, 2015 · N891PC · Substantial damage
  > A total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.
- [NTSB CEN15IA385](https://openairdocs.org/ntsb/CEN15IA385.md): Piper PA-23-250 · Joliet, IL · Incident · No injuries · Incident investigation · Final report · Aug 27, 2015 · N900AM · Minor damage
  > A bird strike.
- [NTSB ERA15WA347](https://openairdocs.org/ntsb/ERA15WA347.md): Cessna TU206B · Lib Mandy, Peru · Accident · 3 fatal · Foreign investigation · Aug 26, 2015 · OB-1616 · Destroyed
- [NTSB CEN15LA379](https://openairdocs.org/ntsb/CEN15LA379.md): Robinson Helicopter R44 II · Ketchum, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2015 · N444KD · Substantial damage
  > The separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.
- [NTSB ERA15LA323](https://openairdocs.org/ntsb/ERA15LA323.md): Cessna 150 · Dorado, PR · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 2015 · N4057V · Substantial damage
  > A short circuit of unknown origin, which resulted in electrical arcing in the engine compartment and smoke in the cockpit, which necessitated a precautionary landing to a field.
- [NTSB ERA15CA327](https://openairdocs.org/ntsb/ERA15CA327.md): Cessna 172 · Riviera Beach, FL · Accident · No injuries · Data collection · Final report · Aug 22, 2015 · N8952B · Substantial damage
  > The pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.
- [NTSB DCA15WA213](https://openairdocs.org/ntsb/DCA15WA213.md): Airbus A330 · Jakarta, Indonesia · Accident · Serious injuries · Foreign investigation · Aug 22, 2015 · PK-GPO · No damage
  > The government of Indonesia has notified the NTSB of an accident involving an AIRBUS A330 that occurred on August 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…
- [NTSB CEN15LA396](https://openairdocs.org/ntsb/CEN15LA396.md): Burns Mini 500 · Butler, MO · Accident · No injuries · Limited investigation · Final report · Aug 21, 2015 · UNREG · Substantial damage
  > The pilot's failure to attain a proper landing flare following an autorotation for reasons that could not be determined based on available information.
- [NTSB CEN15LA395](https://openairdocs.org/ntsb/CEN15LA395.md): Bell Helicopter Textron Canada 429 · Port O'Connor, TX · Accident · No injuries · Limited investigation · Final report · Aug 21, 2015 · N429AR · Substantial damage
  > The fatigue failure of the tail rotor pitch change link spherical bearing housing as a result of corrosion pitting.
- [NTSB CEN15LA383](https://openairdocs.org/ntsb/CEN15LA383.md): Piper PA 25-235 · Harvey, ND · Accident · No injuries · Limited investigation · Final report · Aug 21, 2015 · N4652Y · Substantial damage
  > The partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.
- [NTSB WPR15FA247](https://openairdocs.org/ntsb/WPR15FA247.md): Cessna 172P · Townsend, MT · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2015 · N62731 · Substantial damage
  > The non-instrument-rated pilot's decision to conduct a cross-country flight over a mountain range in dark night conditions with limited night flight experience, which resulted in a collision with mountainous terrain.
- [NTSB CEN15LA369](https://openairdocs.org/ntsb/CEN15LA369.md): Cessna 182P · Bolivar, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2015 · N6KW · Substantial damage
  > Total electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.
- [NTSB ERA15LA318](https://openairdocs.org/ntsb/ERA15LA318.md): Cessna 172K · Chiefland, FL · Accident · No injuries · Limited investigation · Final report · Aug 17, 2015 · N84308 · Substantial damage
  > The partial loss of engine power during cruise flight for reasons that could not be determined because a postaccident airframe and engine examination and engine test run revealed no evidence of mechanical malfunctions or failures.
- [NTSB GAA15CA234](https://openairdocs.org/ntsb/GAA15CA234.md): Burton Dennis W Sonex · Wolcottville, IN · Accident · Minor injuries · Data collection · Final report · Aug 16, 2015 · N683DB · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, a forced off-airport landing, and nose over.
- [NTSB ERA15FA313](https://openairdocs.org/ntsb/ERA15FA313.md): Beech C35 · Hicksville, NY · Accident · 1 fatal · Field investigation · Final report · Aug 16, 2015 · N5946C · Destroyed
  > The pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…
- [NTSB CEN15IA365](https://openairdocs.org/ntsb/CEN15IA365.md): Beech V35 · Mount Vernon, OH · Incident · No injuries · Incident investigation · Final report · Aug 16, 2015 · N2059W · No damage
  > The loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.
- [NTSB ANC15CA064](https://openairdocs.org/ntsb/ANC15CA064.md): Champion 7HC · Coldfoot, AK · Accident · No injuries · Data collection · Final report · Aug 16, 2015 · N8556E · Destroyed
  > The loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.

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

## 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=71

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