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

## Cases, newest first

- [NTSB ERA11CA237](https://openairdocs.org/ntsb/ERA11CA237.md): Cessna 182A · Lesage, WV · Accident · No injuries · Data collection · Final report · Apr 10, 2011 · N4810D · Substantial damage
  > A loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.
- [NTSB WPR11LA193](https://openairdocs.org/ntsb/WPR11LA193.md): Bartholomew Lancair 320 · Temple Bar, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 2011 · N320BB · Substantial damage
  > The pilot did not use carburetor heat in cruise flight while operating in an area conducive to carburetor icing, which resulted in a loss of engine power.
- [NTSB ERA11WA245](https://openairdocs.org/ntsb/ERA11WA245.md): Bell 206B · Santo Andre City, Brazil · Accident · 2 fatal · Foreign investigation · Apr 8, 2011 · PT-YMJ · Destroyed
  > On April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…
- [NTSB CEN11IA286](https://openairdocs.org/ntsb/CEN11IA286.md): Cessna 560XL · Abbeville, LA · Incident · No injuries · Incident investigation · Final report · Apr 8, 2011 · N547CS · No damage
  > The pitch trim control cable failed due to fatigue, rendering the elevator trim inoperative.
- [NTSB CEN11FA274](https://openairdocs.org/ntsb/CEN11FA274.md): Beech A36 · Monaville, TX · Accident · Minor injuries · Field investigation · Final report · Apr 7, 2011 · N24192 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB WPR11FA188](https://openairdocs.org/ntsb/WPR11FA188.md): Aviat A-1C-180 · Laramie, WY · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2011 · N28WY · Substantial damage
  > The pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.
- [NTSB ERA11WA251](https://openairdocs.org/ntsb/ERA11WA251.md): Eurocopter AS-355-F2 · Alto Alegre, Brazil · Accident · 3 fatal · Foreign investigation · Apr 6, 2011 · PT-HNA · Destroyed
  > On April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…
- [NTSB WPR11FA186](https://openairdocs.org/ntsb/WPR11FA186.md): Cessna 177RG · Gila Bend, AZ · Accident · No injuries · Field investigation · Final report · Apr 5, 2011 · N2637V · Substantial damage
  > A total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.
- [NTSB WPR11CA197](https://openairdocs.org/ntsb/WPR11CA197.md): Xtremeair Sbach 342 · Springerville, AZ · Accident · No injuries · Data collection · Final report · Apr 4, 2011 · N142WP · Substantial damage
  > The pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.
- [NTSB ERA11LA230](https://openairdocs.org/ntsb/ERA11LA230.md): Cessna 172P · Vega Baja, PR · Accident · No injuries · Limited investigation · Final report · Apr 1, 2011 · N98FR · Substantial damage
  > The failure of the No. 2 cylinder exhaust valve resulting in a loss of engine power.
- [NTSB DCA11MA039](https://openairdocs.org/ntsb/DCA11MA039.md): Boeing 737 · Yuma, AZ · Accident · Minor injuries · Major investigation · Final report · Apr 1, 2011 · N632SW · Substantial damage
  > the improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…
- [NTSB CEN11CA255](https://openairdocs.org/ntsb/CEN11CA255.md): Cessna 182P · Humnoke, AR · Accident · No injuries · Data collection · Final report · Mar 31, 2011 · N52605 · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN11FA263](https://openairdocs.org/ntsb/CEN11FA263.md): Piper PA-32R-300 · Fredricktown, MO · Accident · 3 fatal · Field investigation · Final report · Mar 29, 2011 · N4085F · Substantial damage
  > The pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.
- [NTSB OPS11IA428](https://openairdocs.org/ntsb/OPS11IA428.md): Cirrus Design SR22 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Mar 27, 2011 · N1487C · 2 aircraft · No damage
  > The air traffic controllers’ application of inappropriate separation between the B737 and the Cirrus and their inappropriate use of airborne civilian aircraft for observation of other airborne aircraft. Contributing to the incident was the crew of the B737's…
- [NTSB ERA11CA217](https://openairdocs.org/ntsb/ERA11CA217.md): Cessna 150F · Hannawana Falls, NY · Accident · No injuries · Data collection · Final report · Mar 26, 2011 · N8830G · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN11LA250](https://openairdocs.org/ntsb/CEN11LA250.md): Embraer EMB-145LR · Kansas City, MO · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 2011 · N931AE · No damage
  > An in-flight encounter with convectively induced turbulence associated with developing thunderstorms under the flight path during the airplane's climb to cruise flight.
- [NTSB ERA11WA252](https://openairdocs.org/ntsb/ERA11WA252.md): Reims-Cessna F-150 · Sotttomarina di Chioggia, Italy · Incident · No injuries · Foreign investigation · Mar 25, 2011 · I-NOLV · No damage
  > On March 25, 2011, about 1200 universal coordinated time, a Reims-Cessna F-150 airplane, Italian registration I-NOLV, had a reported engine failure while in cruise flight. The pilot decided to land on the shoreline in the vicinity of Sottomarina di Chioggia,…
- [NTSB ERA11FA210](https://openairdocs.org/ntsb/ERA11FA210.md): Piper PA-20 · Elgin, SC · Accident · 1 fatal · Field investigation · Final report · Mar 25, 2011 · N7746K · Substantial damage
  > A total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.
- [NTSB ERA11GA207](https://openairdocs.org/ntsb/ERA11GA207.md): Cessna A185F · Ashland, ME · Accident · 1 fatal · Final report · Mar 24, 2011 · N724MT · Substantial damage
  > An inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB CEN11FA244](https://openairdocs.org/ntsb/CEN11FA244.md): Cessna 182M · Hot Springs, AR · Accident · 2 fatal · Field investigation · Final report · Mar 24, 2011 · N70922 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA11LA204](https://openairdocs.org/ntsb/ERA11LA204.md): Robinson R22 · Goshen, NY · Accident · No injuries · Limited investigation · Final report · Mar 22, 2011 · N259TW · Substantial damage
  > The pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.
- [NTSB WPR11FA173](https://openairdocs.org/ntsb/WPR11FA173.md): Cessna P210 · Daggett, CA · Accident · 3 fatal · Field investigation · Final report · Mar 20, 2011 · N50MC · Substantial damage
  > The pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.
- [NTSB CEN11FA240](https://openairdocs.org/ntsb/CEN11FA240.md): Cessna 150D · Baraboo, WI · Accident · 2 fatal · Field investigation · Final report · Mar 20, 2011 · N4178U · Substantial damage
  > The student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.
- [NTSB ERA11LA197](https://openairdocs.org/ntsb/ERA11LA197.md): Burr Andrew E Xiv Rotorway Exec 162F · Lincoln, AL · Accident · No injuries · Limited investigation · Final report · Mar 19, 2011 · N192AB · Substantial damage
  > A total loss of engine power during cruise flight for undetermined reasons.
- [NTSB CEN11CA241](https://openairdocs.org/ntsb/CEN11CA241.md): Cessna 150M · Garland, TX · Accident · Minor injuries · Data collection · Final report · Mar 19, 2011 · N714FS · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN11LA237](https://openairdocs.org/ntsb/CEN11LA237.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Austin, TX · Accident · No injuries · Limited investigation · Final report · Mar 18, 2011 · N141AG · Substantial damage
  > The loss of engine power due to fuel starvation for undetermined reasons.
- [NTSB ENG11IA021](https://openairdocs.org/ntsb/ENG11IA021.md): Bombardier DHC 8 402 · Pittsburgh, PA · Incident · No injuries · Incident investigation · Final report · Mar 17, 2011 · N339NG · Minor damage
  > the flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…
- [NTSB WPR11LA167](https://openairdocs.org/ntsb/WPR11LA167.md): Rotorway A600 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Mar 15, 2011 · N602RW · Substantial damage
  > A design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.
- [NTSB ERA11LA190](https://openairdocs.org/ntsb/ERA11LA190.md): Cessna 182P · Alachua, FL · Accident · No injuries · Limited investigation · Final report · Mar 15, 2011 · N430ML · Substantial damage
  > A loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.
- [NTSB WPR11LA160](https://openairdocs.org/ntsb/WPR11LA160.md): Piper PA-28R-200 · Agoura Hills, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 2011 · N75224 · Substantial damage
  > The loss of engine power during cruise flight for undetermined reasons.
- [NTSB ERA11FA185](https://openairdocs.org/ntsb/ERA11FA185.md): Cessna 310R · Smyrna, TN · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2011 · N310JR · Substantial damage
  > The pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.
- [NTSB CEN11FA227](https://openairdocs.org/ntsb/CEN11FA227.md): Lancair LC41-550FG · Carbondale, IL · Accident · No injuries · Field investigation · Final report · Mar 11, 2011 · N521RT · Substantial damage
  > The fatigue fracture and subsequent failure of the No. 2 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.
- [NTSB ERA11IA184](https://openairdocs.org/ntsb/ERA11IA184.md): Cessna 560XL · Haynesville, VA · Incident · No injuries · Incident investigation · Final report · Mar 10, 2011 · N588QS · No damage
  > The manufacturer's inadequate design fix for previously known tailcone stinger water ingestion and retention.
- [NTSB CEN11LA226](https://openairdocs.org/ntsb/CEN11LA226.md): Robinson Helicopter R22 Beta · Bulverde, TX · Accident · No injuries · Limited investigation · Final report · Mar 9, 2011 · N112HE · Substantial damage
  > The in-flight separation of the fuel cap, which impacted the helicopter’s tail rotor and resulted in the loss of tail rotor thrust. Contributing to the accident was the inadequate preflight inspection by both pilots, who did not ensure that the fuel cap was…
- [NTSB WPR11FA156](https://openairdocs.org/ntsb/WPR11FA156.md): Douglas AD-4N · Twin Falls, ID · Accident · 2 fatal · Field investigation · Final report · Mar 8, 2011 · N2088G · Substantial damage
  > The non-instrument-rated pilot’s encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB ERA11FA182](https://openairdocs.org/ntsb/ERA11FA182.md): Diamond DA-40 · Allagash, ME · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2011 · CGPDO · Substantial damage
  > The pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.
- [NTSB ERA11CA180](https://openairdocs.org/ntsb/ERA11CA180.md): Robinson Helicopter R44 II · Weston, FL · Accident · Serious injuries · Data collection · Final report · Mar 5, 2011 · N4168W · Substantial damage
  > The pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.
- [NTSB ERA11LA179](https://openairdocs.org/ntsb/ERA11LA179.md): Beech C23 · Carrollton, GA · Accident · No injuries · Limited investigation · Final report · Mar 4, 2011 · N6015F · Substantial damage
  > The mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.
- [NTSB WPR11LA149](https://openairdocs.org/ntsb/WPR11LA149.md): Boeing 757-232 · Naches, WA · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 2011 · N684DA · No damage
  > The airplane's encounter with moderate turbulence at a higher altitude than the flight crew expected, resulting in an injury to a cabin crewmember.
- [NTSB WPR11FA147](https://openairdocs.org/ntsb/WPR11FA147.md): Neefjes Lancair 360 MK-II · Milford, UT · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2011 · N989TT · Substantial damage
  > The pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…
- [NTSB CEN11FA202](https://openairdocs.org/ntsb/CEN11FA202.md): Cessna T210M · Independence, MO · Accident · Minor injuries · Field investigation · Final report · Feb 24, 2011 · N6149B · Substantial damage
  > Latent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…
- [NTSB ERA11LA156](https://openairdocs.org/ntsb/ERA11LA156.md): Cessna 172G · Clarksville, FL · Accident · No injuries · Limited investigation · Final report · Feb 23, 2011 · N3740L · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.
- [NTSB ERA11WA211](https://openairdocs.org/ntsb/ERA11WA211.md): Cessna 340 · Tachira, Venezuela · Accident · 6 fatal · Foreign investigation · Feb 22, 2011 · YV2402 · Destroyed
  > On February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…
- [NTSB WPR11LA140](https://openairdocs.org/ntsb/WPR11LA140.md): Rearwin 8135 · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Feb 18, 2011 · NC25545 · Substantial damage
  > The partial loss of engine power due to the separation of an exhaust valve rocker box as a result of the failure of the rocker box attaching studs.
- [NTSB ERA11WA159](https://openairdocs.org/ntsb/ERA11WA159.md): Robinson R44 · Canne della Battaglia, Italy · Accident · 1 fatal · Foreign investigation · Feb 18, 2011 · F-GUJB · Substantial damage
  > On February 18, 2011, about 0706 universal coordinated time, a Robinson R44, French registration F-GUJB, crashed after an in-flight separation of the tail rotor from the fuselage. The pilot was killed. The flight departed Bari, Italy, for Foggia Airport…
- [NTSB ERA11WA155](https://openairdocs.org/ntsb/ERA11WA155.md): Bell 206 · Vereda Galan, Colombia · Accident · 4 fatal · Foreign investigation · Feb 18, 2011 · HK-4594 · Destroyed
  > On February 18, 2011, about 0415 universal coordinated time, a Bell 206-B, Colombian registration HK-4594, operated by Heliservice LTDA, crashed in mountainous terrain near Vereda Galan, Colombia, and was consumed by a post crash fire. Instrument…
- [NTSB ERA11LA150](https://openairdocs.org/ntsb/ERA11LA150.md): Flaglor Tom Kolb Aircraft MK III · Stetson, ME · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 2011 · N213 · Substantial damage
  > The in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.
- [NTSB WPR11LA135](https://openairdocs.org/ntsb/WPR11LA135.md): Cessna 172H · Wikieup, AZ · Accident · No injuries · Limited investigation · Final report · Feb 15, 2011 · N2561L · Substantial damage
  > A total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.
- [NTSB CEN11LA192](https://openairdocs.org/ntsb/CEN11LA192.md): Beech E-90 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Feb 15, 2011 · N51DN · Substantial damage
  > The improper installation of the right aileron by maintenance personnel.
- [NTSB ERA11LA173](https://openairdocs.org/ntsb/ERA11LA173.md): Globe GC-1B · Anderson, SC · Accident · No injuries · Limited investigation · Final report · Feb 14, 2011 · N80741 · Substantial damage
  > The total loss of engine power due to the formation of carburetor ice.

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

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

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