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

## Cases, newest first

- [NTSB DCA18CA316](https://openairdocs.org/ntsb/DCA18CA316.md): Airbus A319 · West Palm Beach, FL · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 23, 2018 · N328NB · No damage
  > An inadvertent encounter with convective turbulence.
- [NTSB DCA18CA251](https://openairdocs.org/ntsb/DCA18CA251.md): Mcdonnell Douglas MD88 · Charlotte, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 23, 2018 · N918DE · No damage
  > An inadvertent encounter with convective turbulence.
- [NTSB CEN18LA287](https://openairdocs.org/ntsb/CEN18LA287.md): Cessna 210C · Blum, TX · Accident · No injuries · Limited investigation · Final report · Jul 21, 2018 · N3611Y · Substantial damage
  > The pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.
- [NTSB WPR18LA199](https://openairdocs.org/ntsb/WPR18LA199.md): Cub Crafters CC19 · Hyrum, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2018 · N70DD · Substantial damage
  > The pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…
- [NTSB CEN18LA284](https://openairdocs.org/ntsb/CEN18LA284.md): Toomey Quickie · Zanesville, OH · Accident · No injuries · Limited investigation · Final report · Jul 19, 2018 · N23JH · Substantial damage
  > The failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.
- [NTSB CEN18FA282](https://openairdocs.org/ntsb/CEN18FA282.md): Fisher Celebrity · Patriot, IN · Accident · 1 fatal · Field investigation · Final report · Jul 19, 2018 · N228LC · Destroyed
  > An in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.
- [NTSB ERA18FA194](https://openairdocs.org/ntsb/ERA18FA194.md): Piper PA34 · Miami, FL · Accident · 4 fatal · Field investigation · Final report · Jul 17, 2018 · N16281 · 2 aircraft · Destroyed
  > The failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.
- [NTSB CEN18LA276](https://openairdocs.org/ntsb/CEN18LA276.md): Beech V35 · Katy, TX · Accident · No injuries · Limited investigation · Final report · Jul 17, 2018 · N228Q · Substantial damage
  > Maintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.
- [NTSB DCA18WA243](https://openairdocs.org/ntsb/DCA18WA243.md): Boeing 737 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Jul 13, 2018 · EI-ENM
  > The government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…
- [NTSB WPR18LA197](https://openairdocs.org/ntsb/WPR18LA197.md): Beech 90 · Tolani Lake, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jul 12, 2018 · N617MM · Substantial damage
  > An autopilot deviation during climb for undetermined reasons, which resulted in an in-flight upset and loss of airplane control. Contributing to the accident was the pilot’s failure to adequately monitor flight systems due to a distraction.
- [NTSB ERA18WA216](https://openairdocs.org/ntsb/ERA18WA216.md): Cessna 501 · Catamarca, Argentina · Incident · No injuries · Foreign investigation · Jul 12, 2018 · LV-CGO · Minor damage
  > The government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…
- [NTSB DCA18WA232](https://openairdocs.org/ntsb/DCA18WA232.md): Boeing 737 · Multan, Pakistan · Incident · Class 5 · Foreign · Jul 12, 2018 · A6-FGB · No damage
- [NTSB CEN18LA275](https://openairdocs.org/ntsb/CEN18LA275.md): Whittman Tailwind · Orient, OH · Accident · No injuries · Limited investigation · Final report · Jul 12, 2018 · N619NT · Substantial damage
  > The pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…
- [NTSB WPR18TA192](https://openairdocs.org/ntsb/WPR18TA192.md): Schempp Hirth Discus CS · Goldfield, NV · Accident · Serious injuries · Final report · Jul 11, 2018 · N104TH · Substantial damage
  > The glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.
- [NTSB GAA18CA421](https://openairdocs.org/ntsb/GAA18CA421.md): Cessna 182 · Lincoln, IL · Accident · No injuries · Data collection · Final report · Jul 11, 2018 · N2394G · Substantial damage
  > The pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB ERA18LA190](https://openairdocs.org/ntsb/ERA18LA190.md): Glasair SH2 · Passadumkeag, ME · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2018 · N352GL · Substantial damage
  > A total loss of engine power due to a fatigue fracture of the crankshaft.
- [NTSB DCA18WA247](https://openairdocs.org/ntsb/DCA18WA247.md): Douglas DC9 · Chichen Itza, Mexico · Incident · No injuries · Foreign investigation · Jul 11, 2018 · N802WA · No damage
  > The Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…
- [NTSB ANC18FA053](https://openairdocs.org/ntsb/ANC18FA053.md): De Havilland DHC 3 · Hydaburg, AK · Accident · Serious injuries · Field investigation · Final report · Jul 10, 2018 · N3952B · Substantial damage
  > The pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA18FA187](https://openairdocs.org/ntsb/ERA18FA187.md): Robinson R44 · Williamsburg, VA · Accident · 2 fatal · Field investigation · Final report · Jul 8, 2018 · N616HS · Destroyed
  > The pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.
- [NTSB CEN18FA259](https://openairdocs.org/ntsb/CEN18FA259.md): Eurocopter Deutschland EC135 P1 · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Jul 8, 2018 · N312SA · Substantial damage
  > The pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…
- [NTSB GAA18CA431](https://openairdocs.org/ntsb/GAA18CA431.md): Cessna 172 · King and Queen, VA · Accident · Minor injuries · Data collection · Final report · Jul 5, 2018 · N1401F · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CEN18WA327](https://openairdocs.org/ntsb/CEN18WA327.md): Columbia LC41-550FG · Vallecillos, Mexico · Accident · No injuries · Foreign investigation · Jul 4, 2018 · XB-OHG · Substantial damage
  > On July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…
- [NTSB GAA18CA392](https://openairdocs.org/ntsb/GAA18CA392.md): Schempp Hirth Discus CS · Pomfret, VT · Accident · No injuries · Data collection · Final report · Jul 3, 2018 · N1122Q · Substantial damage
  > The glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.
- [NTSB DCA18WA246](https://openairdocs.org/ntsb/DCA18WA246.md): Boeing 737 300 · Nassau, Bahamas · Incident · No injuries · Foreign investigation · Jul 3, 2018 · N331CK · No damage
  > The Air Accident Investigation Department (AAID) - Ministry of Tourism, Aviation & Bahamasair has notified the NTSB of an incident involving a Boeing 737 300 airplane that occurred on July 03, 2018. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB CEN18LA247](https://openairdocs.org/ntsb/CEN18LA247.md): Safari 400 · Aguilares, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 2018 · N326RW · Substantial damage
  > The loss of tail rotor control due to the in-flight failure of the tail rotor pinion.
- [NTSB GAA18CA419](https://openairdocs.org/ntsb/GAA18CA419.md): Cessna 152 · Panama City, FL · Accident · No injuries · Data collection · Final report · Jun 30, 2018 · N89887 · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB ERA18LA183](https://openairdocs.org/ntsb/ERA18LA183.md): Bell 206 · Rio Grande, PR · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2018 · N10CV · Substantial damage
  > A total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.
- [NTSB CEN18WA254](https://openairdocs.org/ntsb/CEN18WA254.md): Britten Norman BN2A · Ambergris Caye, Belize · Accident · No injuries · Foreign investigation · Jun 30, 2018 · V3-HFB · Substantial damage
- [NTSB WPR18LA194](https://openairdocs.org/ntsb/WPR18LA194.md): Piper PA32 · Salisbury, NC · Accident · No injuries · Class 3 · Limited · Final report · Jun 29, 2018 · N8440F · Substantial damage
  > A total loss of engine power due to fuel starvation for reasons that could not be determined based on the available information.
- [NTSB DCA18WA238](https://openairdocs.org/ntsb/DCA18WA238.md): Airbus A330 · Gander, Canada · Incident · Minor injuries · Foreign investigation · Jun 29, 2018 · N278AY · No damage
  > The government of Canada has notified the NTSB of an accident involving a Airbus A330 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…
- [NTSB ERA18WA272](https://openairdocs.org/ntsb/ERA18WA272.md): Cessna 172 · Adiyaman, Türkiye · Accident · 1 fatal · Foreign investigation · Jun 27, 2018 · TC-GUB · Destroyed
  > The government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…
- [NTSB GAA18CA377](https://openairdocs.org/ntsb/GAA18CA377.md): Jonker Sailplanes JS1-C · Panguitch, UT · Accident · No injuries · Data collection · Final report · Jun 24, 2018 · N963CG · Substantial damage
  > The pilot’s inability to maintain altitude and his delayed decision to deploy the powered-glider’s engine, which necessitated an off-airport landing.
- [NTSB ERA18LA177](https://openairdocs.org/ntsb/ERA18LA177.md): Crawford RV-7 · Alexander City, AL · Accident · No injuries · Limited investigation · Final report · Jun 24, 2018 · N19MM · Destroyed
  > A total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ANC18FA050](https://openairdocs.org/ntsb/ANC18FA050.md): Piper PA 18-150 · Delta Junction, AK · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2018 · N8664Y · Substantial damage
  > Undetermined based on the available evidence.
- [NTSB WPR18LA174](https://openairdocs.org/ntsb/WPR18LA174.md): Cirrus Design SR22 · Aguila, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 19, 2018 · N764CT · Destroyed
  > A total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.
- [NTSB DCA18CA255](https://openairdocs.org/ntsb/DCA18CA255.md): Embraer ERJ175 · Cut Bank, MT · Accident · Serious injuries · Data collection · Final report · Jun 17, 2018 · N637CZ · No damage
  > an unexpected encounter with clear air turbulence.
- [NTSB CEN18LA229](https://openairdocs.org/ntsb/CEN18LA229.md): Cessna T210F · Desdemona, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 2018 · N6107R · Substantial damage
  > The total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.
- [NTSB ERA18WA237](https://openairdocs.org/ntsb/ERA18WA237.md): Agusta A109 · Espírito Santo, Brazil · Accident · 2 fatal · Foreign investigation · Jun 16, 2018 · PR-JMB · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Agusta A109 helicopter that occurred on June 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB CEN18LA225](https://openairdocs.org/ntsb/CEN18LA225.md): Rockwell International 112TC · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jun 14, 2018 · N4954W · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA18FA167](https://openairdocs.org/ntsb/ERA18FA167.md): Raytheon 58 · Springfield Township, NJ · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2018 · N218BL · Destroyed
  > A loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.
- [NTSB ANC18FA045](https://openairdocs.org/ntsb/ANC18FA045.md): Cessna 175 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2018 · N9423B · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.
- [NTSB DCA18WA207](https://openairdocs.org/ntsb/DCA18WA207.md): Boeing 737 · Otopeni, Romania · Incident · No injuries · Foreign investigation · Jun 12, 2018 · YR-BGG · No damage
  > The Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB DCA18CA219](https://openairdocs.org/ntsb/DCA18CA219.md): Boeing 787-9 · Harbin, China · Accident · Serious injuries · Data collection · Final report · Jun 11, 2018 · N826AN · No damage
  > the accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.
- [NTSB ERA18LA163](https://openairdocs.org/ntsb/ERA18LA163.md): Vans RV4 · Butler, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2018 · N7765X · Substantial damage
  > The pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.
- [NTSB ERA18LA161](https://openairdocs.org/ntsb/ERA18LA161.md): Robinson Helicopter R44 II · Fort Morgan, AL · Accident · No injuries · Limited investigation · Final report · Jun 7, 2018 · N755KT · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN18LA213](https://openairdocs.org/ntsb/CEN18LA213.md): Beech F33A · Uvalde, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 7, 2018 · N3291X · Destroyed
  > The loose oil filter, which resulted in oil starvation and a total loss of engine power in flight.
- [NTSB WPR18WA165](https://openairdocs.org/ntsb/WPR18WA165.md): Cessna 208 · Njabini, Kenya · Accident · 10 fatal · Foreign investigation · Jun 5, 2018 · 5Y-CAC · Destroyed
  > On June 5, 2018, about 1705 local time, a Cessna 208, 5Y-CAC, collided into a mountain in the Aberdare mountain range near Njabini, Kenya. The 2 pilots and 8 passengers were fatally injured; the airplane was destroyed. The airplane was owned and operated by…
- [NTSB CEN18LA207](https://openairdocs.org/ntsb/CEN18LA207.md): Cessna T210 · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Jun 3, 2018 · N66ML · Substantial damage
  > The total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA18LA157](https://openairdocs.org/ntsb/ERA18LA157.md): Piper PA 31 · Amagansett, NY · Accident · 4 fatal · Limited investigation · Final report · Jun 2, 2018 · N41173 · Destroyed
  > The pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.
- [NTSB CEN18LA209](https://openairdocs.org/ntsb/CEN18LA209.md): Luscombe 8A · Longview, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2018 · N72066 · Substantial damage
  > The pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…

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

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

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