# 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 80 of 718 · 35,885 cases

## Cases, newest first

- [NTSB ERA14FA168](https://openairdocs.org/ntsb/ERA14FA168.md): Piper PA-44-180 · Brunswick, GA · Accident · 2 fatal · Field investigation · Final report · Mar 24, 2014 · N923RS · Destroyed
  > An inflight failure of the airplane's only operating vacuum pump, which resulted in the loss of attitude information provided by vacuum-driven flight instruments. Also causal was the pilots' failure to maintain control of the airplane while operating in…
- [NTSB ERA14WA196](https://openairdocs.org/ntsb/ERA14WA196.md): Robinson R22 - Beta · Ribeirão Preto, Brazil · Accident · 2 fatal · Foreign investigation · Mar 23, 2014 · PP-SSP · Substantial damage
  > On March 23, 2014, about 1355 universal coordinated time, a Robinson R22 Beta, Brazilian registration PP-SSP, was substantially damaged when it impacted the ground on a corn plantation in Ribeirao Preto, Brazil. The pilot and a passenger were fatally injured.…
- [NTSB ERA14FA163](https://openairdocs.org/ntsb/ERA14FA163.md): Dehavilland DHC-1 · Vonore, TN · Accident · 1 fatal · Field investigation · Final report · Mar 23, 2014 · N540FM · Substantial damage
  > The pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB CEN14WA176](https://openairdocs.org/ntsb/CEN14WA176.md): Cessna 205 - Undesignat · Albacete, Spain · Accident · No injuries · Foreign investigation · Mar 22, 2014 · EC-GQB · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 22, 2014, about 1630 UTC, a Cessna 205 airplane, EC-GQB, (s/n 205-0277) was involved in a forced landing following…
- [NTSB CEN14LA168](https://openairdocs.org/ntsb/CEN14LA168.md): Olson Perry D Titan 51 Mustang · Evans, CO · Accident · No injuries · Limited investigation · Final report · Mar 21, 2014 · N43889 · Substantial damage
  > The builder's improper wiring of both fuel pumps to the battery-powered bus, which resulted in a total loss of engine power when the batteries failed because all power to the fuel pumps was lost.
- [NTSB DCA14WA104](https://openairdocs.org/ntsb/DCA14WA104.md): Boeing 767-300 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Mar 19, 2014 · D-ABUI
  > The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 767-300 that occurred on March 19, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…
- [NTSB ERA14LA158](https://openairdocs.org/ntsb/ERA14LA158.md): Cessna 172K · Elizabethton, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2014 · N46603 · Substantial damage
  > The pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…
- [NTSB DCA14CA083](https://openairdocs.org/ntsb/DCA14CA083.md): Airbus A330 323 · Seattle (Pacific Ocean) · Accident · Serious injuries · Data collection · Final report · Mar 17, 2014 · N803NW · No damage
  > the flight attendant inadvertently tripping over a passenger's foot that was protruding into the aisle, which resulted in the flight attendant fracturing her foot.
- [NTSB WPR14FA132](https://openairdocs.org/ntsb/WPR14FA132.md): Cessna 120 · Carson City, NV · Accident · 1 fatal · Field investigation · Final report · Mar 9, 2014 · N76856 · Destroyed
  > The pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…
- [NTSB DCA14WA088](https://openairdocs.org/ntsb/DCA14WA088.md): Boeing 737-800 · En route, United Kingdom · Accident · Serious injuries · Foreign investigation · Mar 9, 2014 · EI-DCD · 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 March 9, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…
- [NTSB ERA14LA142](https://openairdocs.org/ntsb/ERA14LA142.md): Cessna 172R · Jackson, TN · Accident · No injuries · Limited investigation · Final report · Mar 5, 2014 · N9417Z · Substantial damage
  > A total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.
- [NTSB ERA14FA138](https://openairdocs.org/ntsb/ERA14FA138.md): Beech F33 · Lumberport, WV · Accident · 1 fatal · Field investigation · Final report · Mar 1, 2014 · N7203E · Destroyed
  > A stroke or cardiovascular event, which resulted in the pilot’s acute impairment or incapacitation and his subsequent flight into terrain.
- [NTSB CEN14CA151](https://openairdocs.org/ntsb/CEN14CA151.md): Bellanca 17 30A · Santa Rosa, NM · Accident · No injuries · Data collection · Final report · Feb 25, 2014 · N9741E · Substantial damage
  > The pilot's mismanagement of the available fuel supply which resulted in a loss of engine power and subsequent emergency landing.
- [NTSB ERA14LA130](https://openairdocs.org/ntsb/ERA14LA130.md): Victor M Cordero RV-9A · Apopka, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2014 · N19VC · Substantial damage
  > The failure of the propeller spline shaft, the drive disk adapter, and the propeller speed reduction unit (PSRU) input spline due to a lack of inspection and lubrication, which resulted in a total loss of propeller drive and a subsequent forced landing.…
- [NTSB DCA14LA060](https://openairdocs.org/ntsb/DCA14LA060.md): Boeing 737 · Kaycee, WY · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 2014 · N23708 · No damage
  > an encounter with severe mountain wave turbulence during cruise flight.
- [NTSB ERA14WA131](https://openairdocs.org/ntsb/ERA14WA131.md): Robinson R44 · Braganca, Brazil · Accident · 2 fatal · Foreign investigation · Feb 15, 2014 · PT-YMF · Substantial damage
  > On February 15, 2014, about 2200 coordinated universal time (UTC), a Robinson, R 44 helicopter, Brazilian registration PT-YMF, was destroyed when it impacted the ground in a dense forest in the Bragança Municipality, in the State of Pará, Brazil. The…
- [NTSB CEN14IA139](https://openairdocs.org/ntsb/CEN14IA139.md): Cirrus Design SR22 · Gunnison, CO · Incident · No injuries · Incident investigation · Final report · Feb 14, 2014 · N18DN · Minor damage
  > The pilot's improper decision to initiate the flight into an area with forecast icing conditions, which resulted in an encounter with in-flight icing conditions that prevented the airplane from being able to maintain altitude.
- [NTSB CEN14CA137](https://openairdocs.org/ntsb/CEN14CA137.md): Piper PA 18-150 · Gordon, NE · Accident · No injuries · Data collection · Final report · Feb 12, 2014 · N83325 · Substantial damage
  > A loss of engine power due to the pilot's improper planning and miscalculation of the fuel supply, which resulted in fuel exhaustion.
- [NTSB CEN14CA182](https://openairdocs.org/ntsb/CEN14CA182.md): Cessna 182J · Belen, NM · Accident · No injuries · Data collection · Final report · Feb 11, 2014 · N300EM · Substantial damage
  > The pilot's failure to ensure adequate fuel onboard for the intended flight.
- [NTSB ERA14CA118](https://openairdocs.org/ntsb/ERA14CA118.md): Bellanca 7KCAB · Sussex, NJ · Accident · No injuries · Data collection · Final report · Feb 9, 2014 · N103KW · Substantial damage
  > The pilot's improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA136](https://openairdocs.org/ntsb/CEN14LA136.md): Mahon Paul D Capella XS · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2014 · N239PM · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB ERA14LA117](https://openairdocs.org/ntsb/ERA14LA117.md): Piper PA-28-161 · Stuart, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 8, 2014 · N2571U · Destroyed
  > The noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.
- [NTSB CEN14GA135](https://openairdocs.org/ntsb/CEN14GA135.md): Cessna 210E · Oden, AR · Accident · 1 fatal · Final report · Jan 31, 2014 · N4957U · Substantial damage
  > The pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.
- [NTSB CEN14CA125](https://openairdocs.org/ntsb/CEN14CA125.md): Cessna 310I · Aurora, CO · Accident · No injuries · Data collection · Final report · Jan 28, 2014 · N8133M · Substantial damage
  > Loss of engine power due to fuel exhaustion and the pilot's inadequate preflight inspection.
- [NTSB DCA14CA043](https://openairdocs.org/ntsb/DCA14CA043.md): General Atomics MQ-9 · Point Loma, CA · Accident · No injuries · Data collection · Final report · Jan 27, 2014 · CBP-159 · Destroyed
  > intentional controlled ditching of the aircraft due to failure of the starter/generator supplying electrical power to the aircraft.
- [NTSB ERA14CA104](https://openairdocs.org/ntsb/ERA14CA104.md): Mooney M20C · Rutherfordton, NC · Accident · No injuries · Data collection · Final report · Jan 26, 2014 · N6762U · Substantial damage
  > The pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA131](https://openairdocs.org/ntsb/CEN14LA131.md): Cessna R182 · Eustis, NE · Accident · No injuries · Limited investigation · Final report · Jan 26, 2014 · N1833R · Substantial damage
  > A catastrophic engine failure, which was initiated by the failure of the No. 5 connecting rod cap.
- [NTSB CEN14CA124](https://openairdocs.org/ntsb/CEN14CA124.md): Cessna R182 · Mt. Morris, IL · Accident · Minor injuries · Data collection · Final report · Jan 25, 2014 · N6359T · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate pre-flight planning and decision-making.
- [NTSB CEN14LA120](https://openairdocs.org/ntsb/CEN14LA120.md): Cessna 414A · Ashland, MO · Accident · No injuries · Limited investigation · Final report · Jan 23, 2014 · N414CJ · Substantial damage
  > The in-flight failure of both engines due to water contamination.
- [NTSB CEN14LA118](https://openairdocs.org/ntsb/CEN14LA118.md): Grumman American Avn. AA 5B · Willow Park, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 2014 · N28578 · Substantial damage
  > The improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.
- [NTSB WPR14LA100](https://openairdocs.org/ntsb/WPR14LA100.md): Ercoupe 415 C · Poulsbo, WA · Accident · 1 fatal · Limited investigation · Final report · Jan 20, 2014 · N2076H · Substantial damage
  > The pilot's failure to confirm that the engine oil filler cap was secured before flight, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.
- [NTSB ERA14FA093](https://openairdocs.org/ntsb/ERA14FA093.md): American Champion 8KCAB · Holland, NJ · Accident · 1 fatal · Field investigation · Final report · Jan 15, 2014 · N469J · Substantial damage
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.
- [NTSB WPR14LA096](https://openairdocs.org/ntsb/WPR14LA096.md): Morrisey 2150 · Pismo Beach, CA · Accident · 2 fatal · Limited investigation · Final report · Jan 14, 2014 · N5102V · Destroyed
  > The in-flight separation of a wing for reasons that could not be determined because the wreckage was not recovered from the ocean.
- [NTSB ERA14LA098](https://openairdocs.org/ntsb/ERA14LA098.md): Israel Aircraft Industries Gulfstream 200 · Savannah, GA · Accident · No injuries · Limited investigation · Final report · Jan 14, 2014 · N720QS · Substantial damage
  > Maintenance personnel’s failure to properly secure the auxiliary power unit service door before returning the airplane to service, which resulted in substantial damage to the rudder.
- [NTSB CEN14IA121](https://openairdocs.org/ntsb/CEN14IA121.md): Cessna 680 · Wheeling, IL · Incident · No injuries · Incident investigation · Final report · Jan 12, 2014 · N531RC · No damage
  > The disconnection of the left elevator trim driveshaft from the trim actuator due to the elevator trim tab drive pin becoming dislodged, which resulted in full nose-down elevator trim.
- [NTSB DCA14CA036](https://openairdocs.org/ntsb/DCA14CA036.md): Boeing 757 232 · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · Jan 10, 2014 · N687DL · No damage
  > unexpected encounter with convective turbulence while the flight attendants were preparing for arrival.
- [NTSB WPR14FA091](https://openairdocs.org/ntsb/WPR14FA091.md): Cirrus Design SR22 · Pocatello, ID · Accident · Minor injuries · Field investigation · Final report · Jan 9, 2014 · N903SR · Substantial damage
  > The distributor gear teeth failure of the right magneto that resulted in severe engine vibration and partial loss of engine power, which progressively led to the failure of the left magneto distributor drive gear teeth. Contributing to the airplane’s…
- [NTSB DCA14CA035](https://openairdocs.org/ntsb/DCA14CA035.md): Boeing 737 7H4 · Nashville, TN · Accident · Serious injuries · Data collection · Final report · Jan 9, 2014 · N966WN · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking lever was raised, which resulted in 2nd degree burns.
- [NTSB CEN14WA105](https://openairdocs.org/ntsb/CEN14WA105.md): Cirrus Design SR22 · Le Pin, France · Accident · No injuries · Foreign investigation · Jan 6, 2014 · F-HAPH · Destroyed
  > On January 6, 2014, approximately 0700 coordinated universal time, a Cirrus SR22 airplane, F-HAPH, lost engine power, deployed the parachute system, and touched down near Le Pin, France. The pilot and passenger were not injured. The flight departed the…
- [NTSB CEN14RA113](https://openairdocs.org/ntsb/CEN14RA113.md): Gippsland GA8 · Cayenne, French Guiana · Accident · Serious injuries · Foreign investigation · Jan 6, 2014 · F-ORPH · Destroyed
  > On January 6, 2014, about 1508 local time, a Gippsland GA-8 Airvan, single engine airplane, F-ORPH, was destroyed during a forced landing following a total loss of engine power at Cayenne – Félix Eboué Airport (SOCA), Cayenne, French Guiana. The pilot…
- [NTSB CEN14FA102](https://openairdocs.org/ntsb/CEN14FA102.md): Mooney M20R · Boyne City, MI · Accident · 2 fatal · Field investigation · Final report · Jan 6, 2014 · N1046L · Substantial damage
  > The pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.
- [NTSB ERA14WA090](https://openairdocs.org/ntsb/ERA14WA090.md): Piper PA-32RT-300T · Margarita, Venezuela · Incident · No injuries · Foreign investigation · Jan 5, 2014 · YV20070 · Minor damage
  > On January 5, 2014, about 1900 universal coordinated time, a Piper PA-32RT-300T, Venezuelan registration YV2070, operated by a private individual, made an emergency landing on a road due a total loss of engine power. The pilot was not injured. The flight…
- [NTSB WPR14CA087](https://openairdocs.org/ntsb/WPR14CA087.md): Prizio Texas Sprt CUB TX11J · Avalon, CA · Accident · No injuries · Data collection · Final report · Jan 4, 2014 · N114DE · Destroyed
  > A total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.
- [NTSB ERA14LA085](https://openairdocs.org/ntsb/ERA14LA085.md): Piper PA-28-180 · Bronx, NY · Accident · No injuries · Limited investigation · Final report · Jan 4, 2014 · N9409J · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined during postaccident engine examination or testing.
- [NTSB CEN14LA112](https://openairdocs.org/ntsb/CEN14LA112.md): Piper PA-22-108 · Forsyth, MO · Accident · No injuries · Limited investigation · Final report · Jan 4, 2014 · N4505Z · Substantial damage
  > The pilot's improper flight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ANC14CA014](https://openairdocs.org/ntsb/ANC14CA014.md): Cessna 170 - B · Nome, AK · Accident · Minor injuries · Data collection · Final report · Jan 4, 2014 · N8177A · Substantial damage
  > The pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power.
- [NTSB ERA14LA083](https://openairdocs.org/ntsb/ERA14LA083.md): Bellanca 17-30A · Alabaster, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 2014 · N351AE · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN14WA208](https://openairdocs.org/ntsb/CEN14WA208.md): Cessna 525A · Honiley, United Kingdom · Accident · No injuries · Foreign investigation · Dec 31, 2013 · N380CR · Substantial damage
- [NTSB WPR14WA085](https://openairdocs.org/ntsb/WPR14WA085.md): Bell 206 · Berastagi, Indonesia · Accident · 1 fatal · Foreign investigation · Dec 30, 2013 · PK-DAL · Destroyed
  > On December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…
- [NTSB WPR14CA097](https://openairdocs.org/ntsb/WPR14CA097.md): Cameron Balloons US A-400 · Napa, CA · Accident · No injuries · Data collection · Final report · Dec 29, 2013 · N65298 · Substantial damage
  > Failure to maintain clearance from obstacles during a descent that resulted in an inadvertent collision with a pole.

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

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

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