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

## Cases, newest first

- [NTSB NYC01IA046](https://openairdocs.org/ntsb/NYC01IA046.md): Mooney M20C · Hazard, KY · Incident · Minor injuries · Incident investigation · Final report · Nov 30, 2000 · N942TB · No damage
  > The incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.
- [NTSB LAX01LA047](https://openairdocs.org/ntsb/LAX01LA047.md): Wsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Kaunakakai, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2000 · N112B · Substantial damage
  > The pilot's improper assessment of in-flight weather conditions, his inadequate compensation for winds, and his failure to maintain sufficient altitude and clearance on the lee side of mountainous terrain.
- [NTSB IAD01IA017](https://openairdocs.org/ntsb/IAD01IA017.md): McDonnell Douglas DC-9-82 · Dulles, VA · Incident · No injuries · Incident investigation · Final report · Nov 29, 2000 · N3507A · Minor damage
  > the operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.
- [NTSB DCA01MA005](https://openairdocs.org/ntsb/DCA01MA005.md): Douglas DC-9 · Atlanta, GA · Accident · Minor injuries · Major investigation · Final report · Nov 29, 2000 · N826AT · Substantial damage
  > the leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…
- [NTSB NYC01LA044](https://openairdocs.org/ntsb/NYC01LA044.md): Bellanca 17-30A · Zanesville, OH · Accident · No injuries · Limited investigation · Final report · Nov 28, 2000 · N8268R · Substantial damage
  > The pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.
- [NTSB FTW01LA028](https://openairdocs.org/ntsb/FTW01LA028.md): Cessna 150L · Valley Spring, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2000 · N18609 · Substantial damage
  > the loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.
- [NTSB FTW01LA026](https://openairdocs.org/ntsb/FTW01LA026.md): Piper PA-46-310P · Gainesville, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2000 · N9298Y · Substantial damage
  > the loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…
- [NTSB IAD01LA110](https://openairdocs.org/ntsb/IAD01LA110.md): Boeing 767 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2000 · EI-CRL · No damage
  > The airplane's inadvertent encounter with severe turbulence.
- [NTSB FTW01FA025](https://openairdocs.org/ntsb/FTW01FA025.md): Cessna 172N · Katy, TX · Accident · 1 fatal · Field investigation · Final report · Nov 26, 2000 · N6521D · 2 aircraft · Substantial damage
  > the failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.
- [NTSB IAD01IA019](https://openairdocs.org/ntsb/IAD01IA019.md): McDonnell Douglas MD-11 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Nov 25, 2000 · N582FE · No damage
  > a short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.
- [NTSB IAD01LA016](https://openairdocs.org/ntsb/IAD01LA016.md): Bellanca BL-17-30A · Union, CT · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2000 · N280H · Substantial damage
  > pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.
- [NTSB DEN01LA017](https://openairdocs.org/ntsb/DEN01LA017.md): 2000 McCoy Genesis · Fort Collins, CO · Accident · 1 fatal · Limited investigation · Final report · Nov 22, 2000 · N9931W · Destroyed
  > Failure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…
- [NTSB MIA01LA032](https://openairdocs.org/ntsb/MIA01LA032.md): Piper PA-32RT-300 · Wewahitchka, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 2000 · N9658C · Substantial damage
  > a loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.
- [NTSB MIA01LA031](https://openairdocs.org/ntsb/MIA01LA031.md): Lake LA-4-200 · Iuka, MS · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2000 · N65717 · Substantial damage
  > a loss of engine power due to fuel contamination resulting in fuel starvation, a forced landing and the subsequent in-flight collision with a wire.
- [NTSB MIA01LA030](https://openairdocs.org/ntsb/MIA01LA030.md): Aerospatiale ATR-72-212 · Ashevelle, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2000 · N630AS · No damage
  > the flight encountered forecasted turbulence, which resulted in serious injury to a flight attendant. Factors in this accident were; the captain's inadequate briefing to the cabin crew; and the insufficient information about the known turbulence that would be…
- [NTSB MIA01FA029](https://openairdocs.org/ntsb/MIA01FA029.md): Airbus Industrie A300B4-605R · Miami, FL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2000 · N14056 · Minor damage
  > The failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…
- [NTSB FTW01LA022](https://openairdocs.org/ntsb/FTW01LA022.md): Cessna 172K · Belcher, LA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2000 · N567QL · Substantial damage
  > the total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.
- [NTSB LAX01LA045](https://openairdocs.org/ntsb/LAX01LA045.md): Collette Glassair III · Guistine, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2000 · N540AK · Substantial damage
  > Maintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…
- [NTSB DEN01LA016](https://openairdocs.org/ntsb/DEN01LA016.md): Piper PA-28-140 · Wendover, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 2000 · N6355R · Substantial damage
  > a forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…
- [NTSB SEA01LA023](https://openairdocs.org/ntsb/SEA01LA023.md): Piper PA-30 · Stevensville, MT · Accident · No injuries · Limited investigation · Final report · Nov 17, 2000 · N7062Y · Substantial damage
  > Fatigue of the right propeller blade resulting in an in-flight separation of the blade tip. A contributing factor was the improper maintenance procedure.
- [NTSB SEA01FA021](https://openairdocs.org/ntsb/SEA01FA021.md): Piper PA-22-135 · Ontario, OR · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2000 · N3762A · Destroyed
  > Overstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.
- [NTSB FTW01FA021](https://openairdocs.org/ntsb/FTW01FA021.md): Eurocopter AS350B2 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2000 · N126TV · Destroyed
  > the pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.
- [NTSB LAX01LA043](https://openairdocs.org/ntsb/LAX01LA043.md): Cessna 210K · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Nov 16, 2000 · N8118G · Substantial damage
  > Failure of the internal cam gear in the remanufactured engine. A factor was the congested obstacles in the forced landing area.
- [NTSB ANC01LA018](https://openairdocs.org/ntsb/ANC01LA018.md): Boeing 737-790 · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2000 · N611AS · No damage
  > An in-flight encounter with clear air turbulence.
- [NTSB LAX01LA040](https://openairdocs.org/ntsb/LAX01LA040.md): Cessna 150E · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 2000 · N4031U · Substantial damage
  > The partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.
- [NTSB CHI01LA037](https://openairdocs.org/ntsb/CHI01LA037.md): Cessna T210N · Kankakee, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 2000 · N9528Y · Substantial damage
  > The unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…
- [NTSB IAD01FA013](https://openairdocs.org/ntsb/IAD01FA013.md): Piper PA-28-140 · Stuart, VA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2000 · N513FL · Destroyed
  > Pilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.
- [NTSB SEA01FA015](https://openairdocs.org/ntsb/SEA01FA015.md): Cessna 152 · Corvallis, OR · Accident · 2 fatal · Field investigation · Final report · Nov 6, 2000 · N53301 · Destroyed
  > The pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.
- [NTSB SEA01LA014](https://openairdocs.org/ntsb/SEA01LA014.md): Boeing 767-332ER · Portland, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2000 · N173DZ · No damage
  > An inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.
- [NTSB NYC01LA026](https://openairdocs.org/ntsb/NYC01LA026.md): Dever Firefly · Berlin, NJ · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2000 · N306K · Substantial damage
  > A loss of power for undetermined reasons.
- [NTSB NYC01LA028](https://openairdocs.org/ntsb/NYC01LA028.md): Beech A-36 · Millersburg, OH · Accident · No injuries · Limited investigation · Final report · Nov 1, 2000 · N565P · Substantial damage
  > The pilot' failure to properly manage the available fuel onboard, which result in fuel starvation, and a loss of engine power.
- [NTSB FTW01LA018](https://openairdocs.org/ntsb/FTW01LA018.md): Piper PA-28-235 · Almyra, AR · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 2000 · N8710W · Substantial damage
  > the loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.
- [NTSB CHI01LA030](https://openairdocs.org/ntsb/CHI01LA030.md): Aviat Pitts S-2B · Worth, IL · Accident · No injuries · Limited investigation · Final report · Nov 1, 2000 · N169DM · Substantial damage
  > The pilot's inadequate preflight of the airplane and his failure to verify the fuel supply on board, which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the lack of suitable…
- [NTSB MIA01FA021](https://openairdocs.org/ntsb/MIA01FA021.md): Piper PA-28-181 · Zolfo Springs, FL · Accident · 1 fatal · Field investigation · Final report · Oct 31, 2000 · N8603E · Substantial damage
  > The loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.
- [NTSB SEA01LA010](https://openairdocs.org/ntsb/SEA01LA010.md): Cessna 150C · Sunnyslope, WA · Accident · No injuries · Limited investigation · Final report · Oct 28, 2000 · N7886Z · Substantial damage
  > The pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.
- [NTSB FTW01FA017](https://openairdocs.org/ntsb/FTW01FA017.md): Aerospatiale AS-350BA · E. Cameron 200 · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2000 · N26WW · Destroyed
  > the loss of engine power due to an internal engine oil leak that started an internal engine fire and the pilot's inadequate autorotation which resulted in a hard landing. A contributing factor to the accident was the rough water condition.
- [NTSB NYC01LA027](https://openairdocs.org/ntsb/NYC01LA027.md): O Loughlin WAG-A-BOND · Greenville, ME · Accident · No injuries · Limited investigation · Final report · Oct 27, 2000 · N51AT · Substantial damage
  > Total loss of engine power for undetermined reasons.
- [NTSB NYC01IA024](https://openairdocs.org/ntsb/NYC01IA024.md): Bombardier CL-600 · Falmouth, KY · Incident · No injuries · Incident investigation · Final report · Oct 26, 2000 · N958CA · No damage
  > The wake turbulence of another heavy airplane.
- [NTSB LAX01FA026](https://openairdocs.org/ntsb/LAX01FA026.md): Cessna 340A · Julian, CA · Accident · 2 fatal · Field investigation · Final report · Oct 26, 2000 · N4347C · Destroyed
  > Total blockage of the instrument static system due to ice.
- [NTSB LAX01LA022](https://openairdocs.org/ntsb/LAX01LA022.md): Beech 35B33 · Bullhead City, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2000 · N8587M · Substantial damage
  > The pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.
- [NTSB LAX01FA023](https://openairdocs.org/ntsb/LAX01FA023.md): Mooney M-20J · Wheaton Springs, CA · Accident · 2 fatal · Field investigation · Final report · Oct 23, 2000 · N40VF · Destroyed
  > The pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.
- [NTSB IAD01IA009](https://openairdocs.org/ntsb/IAD01IA009.md): Raytheon 400A · Morristown, NJ · Incident · No injuries · Incident investigation · Final report · Oct 23, 2000 · N792TA · No damage
  > The failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.
- [NTSB LAX01LA025](https://openairdocs.org/ntsb/LAX01LA025.md): Aerospatiale AS350BA · Kamuela, HI · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 2000 · N12NT · Substantial damage
  > A total loss of engine power due to the failure of the engine manufacturer's repair station personnel to install a circlip during engine overhaul, which resulted in the turbine assembly aft support bearing becoming dislodged and seized on the shaft. A factor…
- [NTSB CHI01LA029](https://openairdocs.org/ntsb/CHI01LA029.md): Fowler Varieze · Iowa City, IA · Accident · Minor injuries · Limited investigation · Final report · Oct 22, 2000 · N82JF · Substantial damage
  > the inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…
- [NTSB NYC01FA021](https://openairdocs.org/ntsb/NYC01FA021.md): Beech BE-23-24 · Kingston, OH · Accident · 3 fatal · Field investigation · Final report · Oct 21, 2000 · N7951L · Substantial damage
  > The pilot's failure to check both fuel tanks visually during the preflight inspection. A factor in the accident was the dark night.
- [NTSB MIA01LA017](https://openairdocs.org/ntsb/MIA01LA017.md): Piper PA-44-180 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 21, 2000 · N928ER · Substantial damage
  > an inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.
- [NTSB IAD01LA008](https://openairdocs.org/ntsb/IAD01LA008.md): Conn Sonerai II · Manassas, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2000 · N188P · Substantial damage
  > Fuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.
- [NTSB IAD01LA007](https://openairdocs.org/ntsb/IAD01LA007.md): Cessna 140 · Mcclure, PA · Accident · No injuries · Limited investigation · Final report · Oct 21, 2000 · N279W · Substantial damage
  > The loss of engine power over unsuitable terrain due to fuel starvation from a fuel strainer blocked with sealant particles.
- [NTSB IAD01FA006](https://openairdocs.org/ntsb/IAD01FA006.md): British Aerospace Jetstream 3201 · Dulles, VA · Accident · No injuries · Field investigation · Final report · Oct 20, 2000 · N488UE · Substantial damage
  > The manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flight
- [NTSB FTW01LA016](https://openairdocs.org/ntsb/FTW01LA016.md): Steven R. Jackson Harmon Rocket 2 · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 2000 · N47SR · Destroyed
  > The collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.

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

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

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