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

## Cases, newest first

- [NTSB ERA18LA259](https://openairdocs.org/ntsb/ERA18LA259.md): Cessna 152 · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Sep 8, 2018 · N6469P · Substantial damage
  > The partial loss of engine power due to a fractured exhaust valve, which resulted in a forced landing on unsuitable terrain and a subsequent rollover.
- [NTSB GAA18CA541](https://openairdocs.org/ntsb/GAA18CA541.md): Cub Crafters CC18 · Northway, AK · Accident · No injuries · Data collection · Final report · Sep 6, 2018 · N413CC · Substantial damage
  > The airplane’s collision with a bird during straight-and-level flight.
- [NTSB GAA18CA538](https://openairdocs.org/ntsb/GAA18CA538.md): Avid Avid Magnum · Carrabassett Valley, ME · Accident · No injuries · Data collection · Final report · Sep 6, 2018 · N2137G · Substantial damage
  > The pilot’s improper decision to initiate the flight in marginal visual flight rules over mountainous terrain, which resulted in an inadvertent encounter with instrument meteorological and downdraft conditions and the subsequent controlled flight into trees…
- [NTSB ERA18WA245](https://openairdocs.org/ntsb/ERA18WA245.md): Bell 430 · Bostanci, Türkiye · Accident · 1 fatal · Foreign investigation · Sep 6, 2018 · TC-HYU · Substantial damage
  > The government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…
- [NTSB DCA18LA285](https://openairdocs.org/ntsb/DCA18LA285.md): Boeing 757 · New York, NY · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 6, 2018 · N173AN · No damage
  > The flight crew’s failure to adequately monitor the airplane’s airspeed, which led to the captain’s aggressive control inputs to increase airspeed; these aggressive inputs resulted in injuries to three cabin crewmembers.
- [NTSB CEN18LA373](https://openairdocs.org/ntsb/CEN18LA373.md): Cessna T310 · Laramie, WY · Accident · No injuries · Class 4 · Limited · Final report · Sep 6, 2018 · N376J · Substantial damage
  > The pilot’s failure to properly adjust the fuel/air mixtures, which resulted in a partial loss of engine power to both engines due to fuel starvation and a subsequent forced landing to a field.
- [NTSB CEN18WA403](https://openairdocs.org/ntsb/CEN18WA403.md): Robin DR400 · Benodet, France · Accident · No injuries · Foreign investigation · Sep 3, 2018 · F-GSBK · Destroyed
  > On September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…
- [NTSB ANC18LA069](https://openairdocs.org/ntsb/ANC18LA069.md): Piper PA32 · Wrangell, AK · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2018 · N3957X · Substantial damage
  > The total loss of engine power due to oil starvation after an interruption of oil circulation for reasons that could not be determined based on the available evidence.
- [NTSB ERA18WA247](https://openairdocs.org/ntsb/ERA18WA247.md): Beech 33 · Taquaraçu de Minas, Brazil · Accident · 1 fatal · Foreign investigation · Sep 1, 2018 · PT-OCB · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB ERA18LA243](https://openairdocs.org/ntsb/ERA18LA243.md): Piper PA12 · Cochranton, PA · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2018 · N3415M · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18LA370](https://openairdocs.org/ntsb/CEN18LA370.md): Cubcrafters CC11-160 · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · Aug 31, 2018 · N71BN · Substantial damage
  > The delayed application of carburetor heat by the pilot which led to accumulation of carburetor ice, eventual loss of engine power, and the subsequent forced landing in high vegetation.
- [NTSB CEN18FA359](https://openairdocs.org/ntsb/CEN18FA359.md): Piper PA28R · Kaplan, LA · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2018 · N7430J · Destroyed
  > The pilot's failure to maintain clearance from a charted and illuminated television/radio tower.
- [NTSB ERA18LA239](https://openairdocs.org/ntsb/ERA18LA239.md): Avid MK-4 · Harnett, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 30, 2018 · N628X · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR18LA248](https://openairdocs.org/ntsb/WPR18LA248.md): Piper PA28 · Tat Momoli, AZ · Accident · No injuries · Class 3 · Limited · Final report · Aug 29, 2018 · N4139A · Substantial damage
  > A total loss of engine power due to a fatigue crack in the connecting rod bushing end.
- [NTSB CEN18LA356](https://openairdocs.org/ntsb/CEN18LA356.md): Air Tractor AT 301 · Partridge, KS · Accident · No injuries · Limited investigation · Final report · Aug 29, 2018 · N3164K · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR18LA250](https://openairdocs.org/ntsb/WPR18LA250.md): Stoddard Hamilton Glasair Super IIS · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Aug 27, 2018 · N8162H · Substantial damage
  > A total loss of engine power as a result of the detachment of the throttle linkage from the throttle arm of the fuel injector servo due to an insufficiently tightened and secured bolt and the subsequent inadequate maintenance inspection.
- [NTSB GAA18CA514](https://openairdocs.org/ntsb/GAA18CA514.md): Cessna 150 · Eldorado, TX · Accident · No injuries · Data collection · Final report · Aug 27, 2018 · N1701Q · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN18LA352](https://openairdocs.org/ntsb/CEN18LA352.md): Cessna 172 · Rushville, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 2018 · N4379L · Substantial damage
  > Loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.
- [NTSB DCA18WA313](https://openairdocs.org/ntsb/DCA18WA313.md): Harbin Y12 · Antioq, Colombia · Incident · No injuries · Foreign investigation · Aug 26, 2018 · HK5036 · Minor damage
  > The Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an incident involving a HAIC Harbin Y12E, which occurred on August 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…
- [NTSB CEN18LA351](https://openairdocs.org/ntsb/CEN18LA351.md): Cessna P210 · Delaware, OH · Accident · No injuries · Limited investigation · Final report · Aug 26, 2018 · N4842K · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s distraction of the formation flight.
- [NTSB ERA18LA228](https://openairdocs.org/ntsb/ERA18LA228.md): Cessna T206 · Pittsfield, ME · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2018 · N35442 · Substantial damage
  > Wear of the No. 4 cylinder exhaust camshaft lobe and roller tappet, which resulted in the failure of the tappet and the subsequent total loss of engine power.
- [NTSB CEN18LA349](https://openairdocs.org/ntsb/CEN18LA349.md): North American T-28B · Minneapolis, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2018 · N215SF · Destroyed
  > The fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.
- [NTSB WPR18FA237](https://openairdocs.org/ntsb/WPR18FA237.md): Champion 7KCAB · Descanso, CA · Accident · 2 fatal · Class 3 · Field · Final report · Aug 22, 2018 · N1682G · Substantial damage
  > The pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…
- [NTSB CEN18WA353](https://openairdocs.org/ntsb/CEN18WA353.md): Piper PA34 · Loma Linda, Costa Rica · Accident · 1 fatal · Foreign investigation · Aug 22, 2018 · TI-BDH · Substantial damage
- [NTSB CEN18LA347](https://openairdocs.org/ntsb/CEN18LA347.md): Piper PA-28-235 · Little Rock, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 2018 · N7954W · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a forced landing on unsuitable terrain.
- [NTSB DCA18WA279](https://openairdocs.org/ntsb/DCA18WA279.md): Boeing 737 · Guadalajara, Mexico · Incident · No injuries · Foreign investigation · Aug 20, 2018 · N520AM · No damage
  > The government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB WPR18TA243](https://openairdocs.org/ntsb/WPR18TA243.md): Beech 36 · Kelso, WA · Accident · No injuries · Final report · Aug 19, 2018 · N9031S · Substantial damage
  > The pilot's fuel mismanagement, which led to fuel starvation, a total loss of engine power, and the subsequent forced landing to a field.
- [NTSB WPR18TA239](https://openairdocs.org/ntsb/WPR18TA239.md): Eurocopter EC130 · Hilo, HI · Accident · Minor injuries · Class 3 · Final report · Aug 19, 2018 · N11QP · Substantial damage
  > The separation of the left sliding door in flight after it opened for reasons that could not be determined based on the available evidence, which resulted in damage to the main rotor blades.
- [NTSB ERA18LA224](https://openairdocs.org/ntsb/ERA18LA224.md): Glasair SHA · Greenville, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 18, 2018 · N38WS · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s misjudgment of the airplane’s glidepath during the forced landing, which resulted in the airplane touching…
- [NTSB ERA18LA227](https://openairdocs.org/ntsb/ERA18LA227.md): Beech 35 · Mayport, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 17, 2018 · N1330Z · Substantial damage
  > The failure of a fuel line due to improper installation of a fuel flow sensor, which resulted in fuel starvation and a subsequent total loss of engine power.
- [NTSB CEN18LA334](https://openairdocs.org/ntsb/CEN18LA334.md): Schweizer 269C · Kindred, ND · Accident · No injuries · Class 3 · Limited · Final report · Aug 16, 2018 · N3625Z · Destroyed
  > The pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…
- [NTSB DCA18WA271](https://openairdocs.org/ntsb/DCA18WA271.md): Boeing 737 · Narrandera, Australia · Incident · No injuries · Foreign investigation · Aug 15, 2018 · VH-XMO · No damage
  > The ATSB of Australia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR18TA223](https://openairdocs.org/ntsb/WPR18TA223.md): Zenair Zenith Stol CH750 · Napa, CA · Accident · No injuries · Final report · Aug 11, 2018 · N328SK · Substantial damage
  > The pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…
- [NTSB DCA18IA264](https://openairdocs.org/ntsb/DCA18IA264.md): Lindstrand 105A · Driggs, ID · Incident · No injuries · Incident investigation · Final report · Aug 10, 2018 · N1410C · 2 aircraft · No damage
  > the drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.
- [NTSB ERA18LA215](https://openairdocs.org/ntsb/ERA18LA215.md): Cessna R182 · Florence, SC · Accident · No injuries · Limited investigation · Final report · Aug 9, 2018 · N1693R · Substantial damage
  > The pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…
- [NTSB WPR18LA221](https://openairdocs.org/ntsb/WPR18LA221.md): Hughes 369 · Honolulu, HI · Accident · No injuries · Class 2 · Limited · Final report · Aug 8, 2018 · N369MH · Substantial damage
  > The operator's improper installation of the tail rotor (TR) teeter bearings, which resulted in cascading in-flight failures of the TR components and attach hardware.
- [NTSB DCA24WA108](https://openairdocs.org/ntsb/DCA24WA108.md): Boeing 737 · Casablanca, Morocco · Incident · Class 5 · Foreign · Aug 6, 2018 · CN-RNJ · No damage
- [NTSB CEN18WA318](https://openairdocs.org/ntsb/CEN18WA318.md): Cessna 172 · Puy-de-Dome Mazoires, France · Accident · 3 fatal · Foreign investigation · Aug 6, 2018 · F-GTNV · Destroyed
  > On August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…
- [NTSB GAA18CA468](https://openairdocs.org/ntsb/GAA18CA468.md): Cessna 185 · Lovelock, NV · Accident · No injuries · Data collection · Final report · Aug 5, 2018 · N9867X · Substantial damage
  > The pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB ANC18FA063](https://openairdocs.org/ntsb/ANC18FA063.md): De Havilland DHC-2 · Talkeetna, AK · Accident · 5 fatal · Field investigation · Final report · Aug 5, 2018 · N323KT · Substantial damage
  > Impact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.
- [NTSB GAA18CA475](https://openairdocs.org/ntsb/GAA18CA475.md): Beech B300 · Wilmington, NC · Accident · No injuries · Data collection · Final report · Aug 1, 2018 · N557AP · Substantial damage
  > The airplane’s collision with a bird during approach.
- [NTSB ANC18WA061](https://openairdocs.org/ntsb/ANC18WA061.md): Piper PA-31 · Calgary, Canada · Accident · 2 fatal · Foreign investigation · Aug 1, 2018 · C-FNCI
  > On August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…
- [NTSB ANC18LA059](https://openairdocs.org/ntsb/ANC18LA059.md): Cessna A185F · White Mountain, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 1, 2018 · N185KB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN18WA304](https://openairdocs.org/ntsb/CEN18WA304.md): Quad City Challenger · North Bay, Canada · Accident · 1 fatal · Foreign investigation · Jul 30, 2018 · C-IGKT · Substantial damage
  > On July 30, 2018, about 1500 Coordinated Universal Time, a Quad City Challenger II airplane, Canadian registration C-IGKT, crashed near Talon Lake, North Bay, Ontario, Canada. The pilot was fatally injured. The flight departed North Bay (CYYB), Ontario, and…
- [NTSB ANC18LA058](https://openairdocs.org/ntsb/ANC18LA058.md): Robinson R44 · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Jul 29, 2018 · N744AK · Substantial damage
  > Maintenance personnel's application of insufficient preload on the attachment hardware for the idler gear shaft during engine overhaul, which resulted in the dismounting of the idler gear shaft assembly due to wear and deformation and the subsequent total…
- [NTSB GAA18CA465](https://openairdocs.org/ntsb/GAA18CA465.md): Bellanca 8GCBC · El Dorado, AR · Accident · No injuries · Data collection · Final report · Jul 27, 2018 · N391KM · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CEN18LA300](https://openairdocs.org/ntsb/CEN18LA300.md): Continental Copters Tomcat MK5A · Le Sueur, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2018 · N9005T · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…
- [NTSB ERA18WA218](https://openairdocs.org/ntsb/ERA18WA218.md): Piper PA34 · Irineopolis, Brazil · Accident · 3 fatal · Foreign investigation · Jul 26, 2018 · PR-DMC · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Piper PA-34-220T that occurred on July 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…
- [NTSB ERA18TA203](https://openairdocs.org/ntsb/ERA18TA203.md): Beech C90 · Lecanto, FL · Accident · No injuries · Final report · Jul 26, 2018 · N717X · Substantial damage
  > The pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.
- [NTSB GAA18CA435](https://openairdocs.org/ntsb/GAA18CA435.md): Cessna 560 · Tulsa, OK · Accident · No injuries · Data collection · Final report · Jul 23, 2018 · N866VP · Substantial damage
  > The airplane’s collision with a bird during approach.

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

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

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