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

## Cases, newest first

- [NTSB ANC14LA034](https://openairdocs.org/ntsb/ANC14LA034.md): Cessna 182K · Galena, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2014 · N2631R · Substantial damage
  > A total loss of engine power for undetermined reasons, which necessitated a forced landing on unsuitable terrain, during which the airplane flipped over and became partially submerged in water.
- [NTSB WPR14FA218](https://openairdocs.org/ntsb/WPR14FA218.md): Nebert Vans RV-10 · Toledo, OR · Accident · 2 fatal · Field investigation · Final report · May 31, 2014 · N62DN · Substantial damage
  > A total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…
- [NTSB ERA14LA272](https://openairdocs.org/ntsb/ERA14LA272.md): Landrum Kelly T Vans RV6 · Suffolk, VA · Accident · Minor injuries · Limited investigation · Final report · May 31, 2014 · N6RP · Substantial damage
  > The pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…
- [NTSB ANC14LA035](https://openairdocs.org/ntsb/ANC14LA035.md): Dehavilland DHC-3T · Homer, AK · Accident · No injuries · Limited investigation · Final report · May 30, 2014 · N3125N · Substantial damage
  > The flutter failure of the right elevator servo tab due to the improper fabrication of the servo tab and maintenance personnel’s subsequent failure to detect anomalies with the servo tab.
- [NTSB ANC14CA033](https://openairdocs.org/ntsb/ANC14CA033.md): Cessna 172F · Fairbanks, AK · Accident · No injuries · Data collection · Final report · May 30, 2014 · N8646U · Substantial damage
  > The pilot's improper inflight planning, which resulted in fuel starvation and a loss of engine power. A factor was the pilot's selection of a low cruise flight altitude, which provided little time for the selection of suitable terrain for the forced landing…
- [NTSB CEN14LA261](https://openairdocs.org/ntsb/CEN14LA261.md): Piper PA-25-235 · Boulder, CO · Accident · Minor injuries · Limited investigation · Final report · May 28, 2014 · N8808L · Substantial damage
  > The pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA14WA275](https://openairdocs.org/ntsb/ERA14WA275.md): Beech B200 · Colonia, Uruguay · Accident · 5 fatal · Foreign investigation · May 27, 2014 · LV-CNT · Substantial damage
  > On May 27, 2014, about 1050 coordinated universal time (UTC), a Beechcraft B200, Argentina registration LV-CNT, was substantially damaged when it impacted the water near Rio de la Plata, Uruguay. The Argentinian pilot and four of the passengers were fatally…
- [NTSB CEN14LA263](https://openairdocs.org/ntsb/CEN14LA263.md): Aero Commander 200D · La Grange, TX · Accident · No injuries · Limited investigation · Final report · May 27, 2014 · N200D · Substantial damage
  > The loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.
- [NTSB CEN14LA253](https://openairdocs.org/ntsb/CEN14LA253.md): Beech A36 · Rockdale, TX · Accident · No injuries · Limited investigation · Final report · May 26, 2014 · N188DP · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.
- [NTSB ERA14CA265](https://openairdocs.org/ntsb/ERA14CA265.md): Divis S L/Waltrip A J RV 4 · Harpswell, ME · Accident · No injuries · Data collection · Final report · May 25, 2014 · N403WD · Substantial damage
  > The pilot's inadequate preflight and in-flight planning which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB WPR14LA208](https://openairdocs.org/ntsb/WPR14LA208.md): Cessna 182P · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · May 24, 2014 · N21048 · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.
- [NTSB WPR14LA207](https://openairdocs.org/ntsb/WPR14LA207.md): Cessna 182 · Arvin, CA · Accident · Minor injuries · Limited investigation · Final report · May 24, 2014 · N97038 · Substantial damage
  > The pilot’s failure to reconnect the air-oil separator return line after completing an oil change, which resulted in a total loss of engine power due to oil starvation.
- [NTSB ERA14WA264](https://openairdocs.org/ntsb/ERA14WA264.md): Beech 58P · Trinidad, Bolivia · Accident · 2 fatal · Class 5 · Foreign · May 23, 2014 · CP-2544 · Destroyed
- [NTSB ERA14FA260](https://openairdocs.org/ntsb/ERA14FA260.md): Grumman American Avn. AA1B · Chester, SC · Accident · 2 fatal · Field investigation · Final report · May 23, 2014 · N8890L · Substantial damage
  > The pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.
- [NTSB ERA14IA249](https://openairdocs.org/ntsb/ERA14IA249.md): Embraer EMB-110P1 · Warren, VT · Incident · No injuries · Incident investigation · Final report · May 21, 2014 · N116WA · Minor damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA244](https://openairdocs.org/ntsb/CEN14LA244.md): Crawford Preceptor Ultra PUP · Mabel, MN · Accident · Minor injuries · Limited investigation · Final report · May 17, 2014 · N1171Q · Substantial damage
  > The loss of engine power as a result of carburetor icing.
- [NTSB DCA14WA095](https://openairdocs.org/ntsb/DCA14WA095.md): Boeing 737-800 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · May 11, 2014 · B-18601 · No damage
  > The Aviation Safety Council (ASC) of Taiwan has notified the NTSB of an incident involving a Boeing 737-800 that occurred on 11 May, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO…
- [NTSB WPR14FA186](https://openairdocs.org/ntsb/WPR14FA186.md): Cessna T207A · Page, AZ · Accident · 1 fatal · Field investigation · Final report · May 10, 2014 · N7311U · Substantial damage
  > The pilot’s inability to maintain aircraft control due to a partial loss of engine power and an encounter with downdrafts and gusting crosswinds while on final approach to the runway. The reason for the partial loss of engine power could not be determined…
- [NTSB ERA14LA227](https://openairdocs.org/ntsb/ERA14LA227.md): Piper PA-28-181 · Covington, TN · Accident · Serious injuries · Limited investigation · Final report · May 7, 2014 · N4506W · Destroyed
  > The pilot’s improper preflight and in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power over unsuitable terrain.
- [NTSB WPR14FA188](https://openairdocs.org/ntsb/WPR14FA188.md): Mooney M20C · Cody, WY · Accident · 2 fatal · Field investigation · Final report · May 6, 2014 · N6704U · Substantial damage
  > The non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.
- [NTSB CEN14LA241](https://openairdocs.org/ntsb/CEN14LA241.md): Kinsler Arthur Paul Kinsler Lancair/Mkii · Crivitz, WI · Accident · Serious injuries · Limited investigation · Final report · May 6, 2014 · N246AK · Substantial damage
  > The improper installation of the hose fuel fitting, which resulted in the fitting becoming disconnected and the subsequent loss of engine power due to fuel starvation.
- [NTSB WPR14LA240](https://openairdocs.org/ntsb/WPR14LA240.md): Cessna T207A · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · May 5, 2014 · N323JC · Substantial damage
  > Maintenance personnel’s application of insufficient torque to the engine cylinder through bolts during replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 main bearing, the bearing shifting, and a catastrophic engine failure.
- [NTSB WPR14LA185](https://openairdocs.org/ntsb/WPR14LA185.md): 177mf Pitts Model 12 · Bluffdale, UT · Accident · Minor injuries · Limited investigation · Final report · May 4, 2014 · N177MF · Substantial damage
  > A complete loss of engine power for reasons that could not be determined because of insufficient evidence.
- [NTSB ERA14LA223](https://openairdocs.org/ntsb/ERA14LA223.md): Messerschmitt-Bolkow-Blohm BK 117 · Hamburg, NY · Accident · No injuries · Limited investigation · Final report · May 4, 2014 · N504TJ · Substantial damage
  > Wear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.
- [NTSB ERA14LA219](https://openairdocs.org/ntsb/ERA14LA219.md): Czech Sport Aircraft A S Sportcruiser · Advance, NC · Accident · Serious injuries · Limited investigation · Final report · May 4, 2014 · N162US · Substantial damage
  > The pilot’s failure to apply carburetor heat during a descent with reduced engine power while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power.
- [NTSB WPR14LA180](https://openairdocs.org/ntsb/WPR14LA180.md): Bell 47G · El Monte, CA · Accident · Minor injuries · Limited investigation · Final report · May 3, 2014 · N7895B · Substantial damage
  > A partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.
- [NTSB CEN14CA227](https://openairdocs.org/ntsb/CEN14CA227.md): Piper PA 24-250 · New Braunfels, TX · Accident · No injuries · Data collection · Final report · May 2, 2014 · N7308P · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.
- [NTSB WPR14LA177](https://openairdocs.org/ntsb/WPR14LA177.md): Airplane Factory Ltd The Sling · Daggett, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2014 · N511NG · Substantial damage
  > The pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.
- [NTSB OPS14IA007](https://openairdocs.org/ntsb/OPS14IA007.md): Boeing 757 · Powhatan, VA · Incident · Minor injuries · Incident investigation · Final report · Apr 29, 2014 · UNK · Minor damage
  > The air traffic controller’s failure to provide required advisories about significant radar-observed convective precipitation along both airplanes’ flight routes and the air route traffic control center’s lack of a program to ensure that air traffic…
- [NTSB CEN14FA224](https://openairdocs.org/ntsb/CEN14FA224.md): Piper PA 32R-300 · Highmore, SD · Accident · 4 fatal · Field investigation · Final report · Apr 28, 2014 · N8700E · Destroyed
  > The pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…
- [NTSB CEN14LA218](https://openairdocs.org/ntsb/CEN14LA218.md): Beech A36 · Wann, OK · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 2014 · N3078Y · Substantial damage
  > The pilot's inadequate preflight inspection and planning and inflight fuel management, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing in an area of unsuitable terrain.
- [NTSB WPR14FA172](https://openairdocs.org/ntsb/WPR14FA172.md): NBB Glasair III · Young, AZ · Accident · 1 fatal · Field investigation · Final report · Apr 26, 2014 · N911EX · Destroyed
  > The noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.
- [NTSB CEN14LA226](https://openairdocs.org/ntsb/CEN14LA226.md): Flight Design Ctls · Greenville, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 2014 · N106SF · Substantial damage
  > The fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.
- [NTSB CEN14LA228](https://openairdocs.org/ntsb/CEN14LA228.md): Brecher Rotorway Exec · Richwood, OH · Accident · Serious injuries · Limited investigation · Final report · Apr 24, 2014 · N43691 · Substantial damage
  > The flight instructor’s inadequate autorotation, which resulted in a hard landing and postcrash fire. Contributing was the flight instructor’s lack of experience in performing an autorotation in the accident make and model of helicopter.
- [NTSB DCA14WA151](https://openairdocs.org/ntsb/DCA14WA151.md): Piper PA46 · Kimberley, South Africa · Accident · 2 fatal · Foreign investigation · Apr 22, 2014 · ZS-LLD · Destroyed
- [NTSB ERA14LA202](https://openairdocs.org/ntsb/ERA14LA202.md): Oconnor Paul A Ultimate Aero 10-200 · Saint Albans, VT · Accident · No injuries · Limited investigation · Final report · Apr 18, 2014 · N827D · Destroyed
  > The propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.
- [NTSB CEN14LA204](https://openairdocs.org/ntsb/CEN14LA204.md): Cessna 210A · Searcy, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 2014 · N9421X · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.
- [NTSB WPR14CA168](https://openairdocs.org/ntsb/WPR14CA168.md): Linstrand 240A · Mayer, AZ · Accident · Minor injuries · Data collection · Final report · Apr 14, 2014 · N2646Z · Substantial damage
  > The balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.
- [NTSB ERA14LA198](https://openairdocs.org/ntsb/ERA14LA198.md): Piper PA-18-135 · Aguas Buenas, PR · Accident · No injuries · Limited investigation · Final report · Apr 13, 2014 · N2875D · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14FA198](https://openairdocs.org/ntsb/CEN14FA198.md): Beech C24 · Denton, TX · Accident · 1 fatal · Field investigation · Final report · Apr 13, 2014 · N23984 · Substantial damage
  > The pilot mistakenly manipulated the airplane's mixture knob rather than the propeller control knob during the descent, reducing the airplane's mixture knob to where the fuel-air mixture to the engine was too lean, which caused the engine to fail, and the…
- [NTSB CEN14LA195](https://openairdocs.org/ntsb/CEN14LA195.md): Larsen Mark V · Amelia, OH · Accident · No injuries · Limited investigation · Final report · Apr 12, 2014 · N87JL · Substantial damage
  > The distributor failure, which resulted in a total loss of engine power during cruise climb.
- [NTSB WPR14FA165](https://openairdocs.org/ntsb/WPR14FA165.md): Williams Myron G Bowers FLY Baby 1A · Mariposa, CA · Accident · 1 fatal · Field investigation · Final report · Apr 11, 2014 · N6054Q · Substantial damage
  > The partial loss of engine power due to an improperly maintained carburetor and the pilot's subsequent failure to maintain aircraft control.
- [NTSB ERA14LA193](https://openairdocs.org/ntsb/ERA14LA193.md): Cessna U206G · Louisa, VA · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 2014 · N156SA · Substantial damage
  > The pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…
- [NTSB ERA14FA192](https://openairdocs.org/ntsb/ERA14FA192.md): Piper PA-32RT-300T · Hugheston, WV · Accident · 2 fatal · Field investigation · Final report · Apr 11, 2014 · N39965 · Destroyed
  > The pilot's loss of airplane control while operating in instrument flight rules conditions.
- [NTSB ERA14WA207](https://openairdocs.org/ntsb/ERA14WA207.md): Embraer EMB-720D · Aripuanã, Brazil · Accident · 4 fatal · Foreign investigation · Apr 6, 2014 · PT-ROS · Destroyed
  > On April 6, 2014, about 1130 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-ROS, was destroyed when it impacted trees and terrain near Aripuanã, Brazil. The pilot and three passengers were fatally injured. The flight originated…
- [NTSB CEN14LA194](https://openairdocs.org/ntsb/CEN14LA194.md): Cessna T210M · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 2014 · N761BT · Substantial damage
  > The pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.
- [NTSB ERA14WA187](https://openairdocs.org/ntsb/ERA14WA187.md): Piper PA-30 · Collagna, Italy · Accident · 1 fatal · Foreign investigation · Apr 4, 2014 · N678AL · Destroyed
  > On April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…
- [NTSB ERA14LA179](https://openairdocs.org/ntsb/ERA14LA179.md): Cessna T210L · Clayton, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 2014 · N1631X · Substantial damage
  > Maintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.
- [NTSB ERA14LA183](https://openairdocs.org/ntsb/ERA14LA183.md): Robert J Reimbold Zenith CH 750 · Venus, FL · Accident · No injuries · Limited investigation · Final report · Apr 2, 2014 · N938VP · Substantial damage
  > The fuel system’s inadequate design, which resulted in negative pressure in the right fuel tank and a total loss of engine power during cruise flight due to fuel starvation.
- [NTSB WPR14TA149](https://openairdocs.org/ntsb/WPR14TA149.md): Bell OH-58A · Tehachapi, CA · Accident · No injuries · Final report · Mar 27, 2014 · N497E · Substantial damage
  > The pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…

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

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

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