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

## Cases, newest first

- [NTSB LAX92MA184](https://openairdocs.org/ntsb/LAX92MA184.md): Beech E18S · Mount Haleakala, HI · Accident · 9 fatal · Class 1 · Major · Final report · Apr 23, 1992 · N342E · Destroyed
  > The captain's decision to continue visual flight into instrument meteorological conditions that obscured rising mountainous terrain and his failure to properly use available navigational information to remain clear of the island of maui. Contributing to the…
- [NTSB CHI92LA131](https://openairdocs.org/ntsb/CHI92LA131.md): Cessna 152 · Branson, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 1992 · N59ND · 2 aircraft · Substantial damage
  > Inadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.
- [NTSB SEA92LA082](https://openairdocs.org/ntsb/SEA92LA082.md): Beech B36TC · Mona, UT · Accident · No injuries · Limited investigation · Final report · Apr 22, 1992 · N7252X · Substantial damage
  > A fatigue failure to the crankshaft and a manufacturing material defect.
- [NTSB MIA92FA112](https://openairdocs.org/ntsb/MIA92FA112.md): Navion NAV-A · Monteverde, FL · Accident · 1 fatal · Field investigation · Final report · Apr 22, 1992 · N4904E · Destroyed
  > The pilot's inadvertent flight into IMC conditions and subsequent loss of control of the airplane in flight.
- [NTSB NYC92DNC02](https://openairdocs.org/ntsb/NYC92DNC02.md): Craig Morehead Bushby Mustang II · Buxton, ME · Accident · 1 fatal · Final report · Apr 20, 1992 · N519CS · Destroyed
  > The failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.
- [NTSB LAX92LA180](https://openairdocs.org/ntsb/LAX92LA180.md): Cessna 150 · Mesquite, NV · Accident · No injuries · Limited investigation · Final report · Apr 19, 1992 · N6582G · Substantial damage
  > The pilot's poor preflight planning and improper fuel consumption calculations. Factors relating to this accident were fuel exhaustion, and the unsuitable terrain, and lack of understanding of the airplane's fuel system.
- [NTSB LAX92LA179](https://openairdocs.org/ntsb/LAX92LA179.md): Homebuilt Dragonfly · Parker, AZ · Accident · No injuries · Limited investigation · Final report · Apr 19, 1992 · N235JS · Destroyed
  > An oil leak from an unidentified source. The high vegetation along the forced landing area contributed to this accident.
- [NTSB NYC92LA081](https://openairdocs.org/ntsb/NYC92LA081.md): Cessna 172N · Blaine Hill, PA · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1992 · N172DG · Destroyed
  > A leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.
- [NTSB CHI92LA130](https://openairdocs.org/ntsb/CHI92LA130.md): Cessna 152 · Hanover, IN · Accident · No injuries · Limited investigation · Final report · Apr 18, 1992 · N46034 · Substantial damage
  > Inadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.
- [NTSB SEA92LA081](https://openairdocs.org/ntsb/SEA92LA081.md): Piper J-5A · Broadus, MT · Accident · No injuries · Limited investigation · Final report · Apr 17, 1992 · N35931 · Substantial damage
  > Fuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.
- [NTSB FTW92LA115](https://openairdocs.org/ntsb/FTW92LA115.md): Luscombe 8E · Acton, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1992 · N2430K · Substantial damage
  > The excessive airspeed during the landing. Factors were the carburetor icing conditions, the carburetor ice induced power loss, and the pilot's delayed use of carburetor heat.
- [NTSB LAX92LA178](https://openairdocs.org/ntsb/LAX92LA178.md): Cessna 150G · Galt, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 1992 · N6213S · Destroyed
  > The pilot's poor in-flight decision by selecting an improper cruise altitude. Contributing to this accident was the pilot's fatigue due to lack of sleep.
- [NTSB ATL92LA081](https://openairdocs.org/ntsb/ATL92LA081.md): Aeronca 7DC · Elgin, SC · Accident · No injuries · Limited investigation · Final report · Apr 16, 1992 · N2901E · Substantial damage
  > The improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.
- [NTSB LAX92FA172](https://openairdocs.org/ntsb/LAX92FA172.md): Piper PA-28R-200 · Placerville, CA · Accident · 2 fatal · Field investigation · Final report · Apr 13, 1992 · N2968R · Destroyed
  > The pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…
- [NTSB NYC92FA078](https://openairdocs.org/ntsb/NYC92FA078.md): Piper PA-28R-200 · Narrows, VA · Accident · 4 fatal · Field investigation · Final report · Apr 12, 1992 · N16540 · Destroyed
  > The pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…
- [NTSB LAX92FA174](https://openairdocs.org/ntsb/LAX92FA174.md): Cessna P210N · Baxter, CA · Accident · 5 fatal · Field investigation · Final report · Apr 12, 1992 · N9TG · Destroyed
  > 1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…
- [NTSB DEN92IA046](https://openairdocs.org/ntsb/DEN92IA046.md): Cessna 310-L · Hugo, CO · Incident · No injuries · Incident investigation · Final report · Apr 12, 1992 · N331BX · No damage
  > Failure of the left voltage regulator. Factors were: failure of the pilot/mechanic to properly maintain the aircraft, and failure of the right alternator circuit breaker.
- [NTSB ATL92FA076](https://openairdocs.org/ntsb/ATL92FA076.md): Piper PA-28-140 · Young Harris, GA · Accident · 2 fatal · Field investigation · Final report · Apr 12, 1992 · N7248J · Destroyed
  > The failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.
- [NTSB ATL92IA078](https://openairdocs.org/ntsb/ATL92IA078.md): Maule M-5-210 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Apr 11, 1992 · N51590 · Minor damage
  > The failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.
- [NTSB SEA92LA072](https://openairdocs.org/ntsb/SEA92LA072.md): Piper PA-23-160 · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Apr 10, 1992 · N3494P · Substantial damage
  > Partial blockage of the left engine induction air filter, inability to maintain the proper rate of descent, and delayed extension of the landing gear. Factors contributing to the accident were icing conditions, wing ice, and rough/uneven terrain.
- [NTSB LAX92LA176](https://openairdocs.org/ntsb/LAX92LA176.md): Mcewen Dick Glasair III · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Apr 10, 1992 · N115DM · Substantial damage
  > A failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…
- [NTSB FTW92GA111](https://openairdocs.org/ntsb/FTW92GA111.md): Piper PA-32R-301T · Albuquerque, NM · Accident · 1 fatal · Final report · Apr 9, 1992 · N8194X · Substantial damage
  > Fuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.
- [NTSB FTW92FA112](https://openairdocs.org/ntsb/FTW92FA112.md): Bell 206L-3 · Venice, LA · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1992 · N6610L · Destroyed
  > The pilot's incapacitation due to food poisoning.
- [NTSB LAX92LA170](https://openairdocs.org/ntsb/LAX92LA170.md): Cessna 182 · Delano, CA · Accident · No injuries · Limited investigation · Final report · Apr 8, 1992 · N5195D · Substantial damage
  > A loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to land the airplane and the soft soil condition which caused the airplane to nose over.
- [NTSB FTW92LA122](https://openairdocs.org/ntsb/FTW92LA122.md): Cessna A188B · Washita, OK · Accident · No injuries · Limited investigation · Final report · Apr 6, 1992 · N70321 · Substantial damage
  > The failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.
- [NTSB ATL92LA074](https://openairdocs.org/ntsb/ATL92LA074.md): Cessna 150H · Elizabeth City, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1992 · N23380 · Substantial damage
  > Inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.
- [NTSB SEA92LA068](https://openairdocs.org/ntsb/SEA92LA068.md): Cessna 177RG · Scappoose, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1992 · N52638 · Destroyed
  > The loss of engine power, cause undetermined. A factor relating to the accident was the lack of suitable terrain for a forced landing.
- [NTSB LAX92LA165](https://openairdocs.org/ntsb/LAX92LA165.md): Robinson R22B · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1992 · N40433 · Substantial damage
  > The pilot's failure to maintain a proper cruise altitude upon entering a mountain pass area, and his failure to maintain control of the helicopter. Factors which contributed to the pilot's loss of control were related to his encountering turbulence and…
- [NTSB LAX92LA163](https://openairdocs.org/ntsb/LAX92LA163.md): Cessna 152 · Yucca Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 1992 · N24977 · Destroyed
  > Was the loss of engine power for undetermined reasons. A factor in the accident was the mountainous and rough nature of the terrain.
- [NTSB ATL92LA073](https://openairdocs.org/ntsb/ATL92LA073.md): Cessna 210 · Florence, SC · Accident · No injuries · Limited investigation · Final report · Apr 3, 1992 · N7320E · Substantial damage
  > The improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…
- [NTSB MIA92LA102](https://openairdocs.org/ntsb/MIA92LA102.md): Bell 47-D-1 · Fayette, MS · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1992 · N322A · Substantial damage
  > The pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.
- [NTSB FTW92LA102](https://openairdocs.org/ntsb/FTW92LA102.md): R. W. Switzer RV-4 · Rogers, AR · Accident · No injuries · Limited investigation · Final report · Apr 2, 1992 · N94BS · Substantial damage
  > Loss of engine due to fuel starvation and unsuitable terrain. Factors were the pilot's failure to follow published procedures.
- [NTSB SEA92LA066](https://openairdocs.org/ntsb/SEA92LA066.md): Avid Mark IV · Soldier Summit, UT · Accident · No injuries · Limited investigation · Final report · Apr 1, 1992 · N582MK · Substantial damage
  > The fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.
- [NTSB CHI92FA120](https://openairdocs.org/ntsb/CHI92FA120.md): Cessna 182 · Port Washington, WI · Accident · 2 fatal · Field investigation · Final report · Apr 1, 1992 · N1230D · Destroyed
  > The continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.
- [NTSB CHI92FA119](https://openairdocs.org/ntsb/CHI92FA119.md): Cessna 172H · Browntown, WI · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1992 · N3884R · Destroyed
  > Spatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…
- [NTSB ANC92LA056](https://openairdocs.org/ntsb/ANC92LA056.md): Cessna 150 · Kalskag, AK · Accident · 2 fatal · Limited investigation · Final report · Apr 1, 1992 · N11140 · Substantial damage
  > The pilot's failure to maintain control of the airplane as a result of his physical impairment due to alcohol. A factor was the dark night.
- [NTSB DEN92FA045](https://openairdocs.org/ntsb/DEN92FA045.md): Cessna T210N · Larkspur, CO · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1992 · N212CS · Destroyed
  > The pilot's failure to flare the airplane due to his reduced forward visibility. Factors were: the pilot's improper fuel consumption calculations, his failure to proceed to an alternate airport, fuel exhaustion, and weather conditions including snow, fog, and…
- [NTSB LAX92FA156](https://openairdocs.org/ntsb/LAX92FA156.md): Beech B95 · Devore, CA · Accident · 3 fatal · Field investigation · Final report · Mar 29, 1992 · N9652R · Destroyed
  > The pilot's failure to maintain an adequate altitude while flying over mountainous terrain. Factors related to the accident were: the low clouds, dark night, and mountainous terrain.
- [NTSB ATL92LA072](https://openairdocs.org/ntsb/ATL92LA072.md): Cessna U206G · Lafayette, TN · Accident · No injuries · Limited investigation · Final report · Mar 29, 1992 · N9679G · Substantial damage
  > The pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.
- [NTSB ANC92LA055](https://openairdocs.org/ntsb/ANC92LA055.md): Piper PA-28-161 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Mar 29, 1992 · N82757 · Substantial damage
  > Terrain clearance was not maintained. Factors to the accident were: snow covered hilly terrain, and diverted attention.
- [NTSB LAX92LA252](https://openairdocs.org/ntsb/LAX92LA252.md): Beech B-35 · Newhall, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1992 · N8838A · Substantial damage
  > Improper ruddervator balancing that resulted in ruddervator flutter. Contributing to the accident was insufficient maintenance information to assure that AD compliance and elevator balancing was performed, and an inadequate annual inspection procedure that…
- [NTSB CHI92LA118](https://openairdocs.org/ntsb/CHI92LA118.md): Cessna TR182 · Joliet, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1992 · N4822R · Destroyed
  > The pilot-in-command's failure to follow emergency procedures, and the failure of the electrical system. Factors contributing to the accident were electrical arcing, and the lack of total experience in the type of aircraft by the pilot-in-command.
- [NTSB LAX92FA151](https://openairdocs.org/ntsb/LAX92FA151.md): Piper PA 28-236 · Lebec, CA · Accident · 1 fatal · Field investigation · Final report · Mar 27, 1992 · N4335N · Destroyed
  > The pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.
- [NTSB MIA92LA101](https://openairdocs.org/ntsb/MIA92LA101.md): Maya, Jaime Rans S-12 · Cabo Rojo, PR · Accident · Serious injuries · Limited investigation · Final report · Mar 22, 1992 · UNREG · Substantial damage
  > Failure of the non FAA certificated pilot to maintain airspeed and the inadvertent stall during an attempted precautionary landing following partial loss of engine power due to undetermined reasons.
- [NTSB CHI92LA117](https://openairdocs.org/ntsb/CHI92LA117.md): Beech F33A · Langdon, ND · Accident · No injuries · Limited investigation · Final report · Mar 21, 1992 · N2046W · Substantial damage
  > Failure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.
- [NTSB ATL92LA065](https://openairdocs.org/ntsb/ATL92LA065.md): Lake LA-4-200 · Hull, GA · Accident · No injuries · Limited investigation · Final report · Mar 18, 1992 · N111TY · Substantial damage
  > The pilot's inadequate preflight and inflight planning, which resulted in fuel exhaustion, and his failure to obtain a proper touchdown point, which resulted in a long landing and collision with terrain.
- [NTSB SEA92LA062](https://openairdocs.org/ntsb/SEA92LA062.md): North American Navion · Elbe, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1992 · N4021K · Destroyed
  > Fuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.
- [NTSB MIA92LA098](https://openairdocs.org/ntsb/MIA92LA098.md): Mooney M20K · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 1992 · N231KF · Substantial damage
  > The separation of the swage between the throttle outer housing and throttle cable resulting in loss of throttle control and the engine reducing to idle power.
- [NTSB LAX92LA143](https://openairdocs.org/ntsb/LAX92LA143.md): Cessna 172E · Yucapia, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 1992 · N5417T · Substantial damage
  > The partial loss of power most likely related to the poor quality of aircraft maintenance. A factor in the accident was the lack of suitable terrain for a forced landing.
- [NTSB LAX92FA141](https://openairdocs.org/ntsb/LAX92FA141.md): Mooney M20C · Redding, CA · Accident · 2 fatal · Field investigation · Final report · Mar 16, 1992 · N7850V · Destroyed
  > A loss of engine power due to carburetor and air filter icing, and, the pilots decision to attempt flight into known adverse weather/icing conditions.

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

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

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