# NTSB investigations: Approach

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 55 of 420 · 20,992 cases

## Cases, newest first

- [NTSB ERA11LA229](https://openairdocs.org/ntsb/ERA11LA229.md): Piper PA-28R-180 · Ridgely, MD · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2011 · N7619J · Substantial damage
  > The pilot receiving instruction's inadequate compensation for the wind during landing and delay in executing a go-around, which resulted in a loss of airspeed, low final approach, and subsequent collision with the ground short of the runway. Contributing to…
- [NTSB CEN11FA267](https://openairdocs.org/ntsb/CEN11FA267.md): Cirrus Design SR-22 · South Bend, IN · Accident · 1 fatal · Field investigation · Final report · Apr 4, 2011 · N847C · Substantial damage
  > The pilot’s failure to maintain airplane control while on final approach with a gusting crosswind and the subsequent aerodynamic stall and spin during the attempted go-around.
- [NTSB ERA11CA225](https://openairdocs.org/ntsb/ERA11CA225.md): Piper PA38 · Manville, NJ · Accident · Serious injuries · Data collection · Final report · Apr 2, 2011 · N2491K · Substantial damage
  > The pilot’s improper fuel management which resulted in a loss of engine power due to fuel starvation.
- [NTSB DCA11FA072](https://openairdocs.org/ntsb/DCA11FA072.md): Bombardier CL600 2B19 · Phoenix, AZ · Accident · No injuries · Field investigation · Final report · Apr 2, 2011 · N7264V · Substantial damage
  > inadequate clearance between the Integrated Drive Generator (IDG) power cables and hydraulic lines in the aft equipment bay that resulted in chaffing of the IDG power cables and hydraulic lines, arcing, and fire.
- [NTSB CEN11LA266](https://openairdocs.org/ntsb/CEN11LA266.md): Cessna 172RG · Wellington, CO · Accident · No injuries · Limited investigation · Final report · Apr 2, 2011 · N4914V · Substantial damage
  > The certified flight instructor's failure to maintain directional control during the go-around.
- [NTSB ERA11FA219](https://openairdocs.org/ntsb/ERA11FA219.md): Beech 58 · Greensboro, NC · Accident · 2 fatal · Field investigation · Final report · Mar 30, 2011 · N569JL · Substantial damage
  > The pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.
- [NTSB ERA11FA218](https://openairdocs.org/ntsb/ERA11FA218.md): Cessna 310R · Pikeville, KY · Accident · 2 fatal · Field investigation · Final report · Mar 30, 2011 · N1914G · Substantial damage
  > The pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…
- [NTSB ERA11CA205](https://openairdocs.org/ntsb/ERA11CA205.md): Cessna 172M · Statesville, NC · Accident · Minor injuries · Data collection · Final report · Mar 23, 2011 · N32SF · Substantial damage
  > The certified flight instructor's inadequate remedial action during the go-around, which resulted in a collision with trees.
- [NTSB ERA11LA198](https://openairdocs.org/ntsb/ERA11LA198.md): Piper PA-32R-300 · Vineyard Haven, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 20, 2011 · N2027M · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR11LA169](https://openairdocs.org/ntsb/WPR11LA169.md): Cirrus SR22 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Mar 19, 2011 · N329SM · Substantial damage
  > The pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…
- [NTSB WPR11LA168](https://openairdocs.org/ntsb/WPR11LA168.md): Cessna TU206G · Puyallup, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 2011 · N6169Z · Substantial damage
  > The pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.
- [NTSB WPR11FA170](https://openairdocs.org/ntsb/WPR11FA170.md): Cessna T310R · Butte, MT · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2011 · N4914A · Substantial damage
  > The pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…
- [NTSB ERA11CA195](https://openairdocs.org/ntsb/ERA11CA195.md): Brown Narcisse A Christen Eagle II · Gainesville, FL · Accident · Serious injuries · Data collection · Final report · Mar 19, 2011 · N109BX · Substantial damage
  > The pilot's failure to maintain airspeed while turning from base leg to final approach, which resulted in an aerodynamic stall and collision with the ground.
- [NTSB CEN11CA238](https://openairdocs.org/ntsb/CEN11CA238.md): Cessna 305A · Anoka, MN · Accident · No injuries · Data collection · Final report · Mar 19, 2011 · N269TH · Substantial damage
  > The pilot's failure to maintain control of the airplane during the go-around, which resulted in an inadvertent stall.
- [NTSB CEN11CA224](https://openairdocs.org/ntsb/CEN11CA224.md): Ayres S2R-T34 · Swan Lake, AR · Accident · Minor injuries · Data collection · Final report · Mar 12, 2011 · N92KM · Substantial damage
  > An in-flight collision with power lines following an encounter with a wind gust.
- [NTSB ERA11FA183](https://openairdocs.org/ntsb/ERA11FA183.md): Dehavilland DHC-6-100 · Hampton, GA · Accident · 2 fatal · Field investigation · Final report · Mar 8, 2011 · N157KM · Substantial damage
  > The pilot did not maintain airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB ERA11WA220](https://openairdocs.org/ntsb/ERA11WA220.md): Beech B200 · Vichada, Colombia · Incident · No injuries · Foreign investigation · Mar 6, 2011 · HK4108 · Substantial damage
  > On March 6, 2011, about 2140 Universal Coordinated Time (UTC), a Beech BE-200, Columbian registration HK-4108, operated by Servicio Aereo de Capurgana (SEARCA S.A.), was substantially damaged during landing at Vichada, Columbia, following loss of engine…
- [NTSB ERA11LA175](https://openairdocs.org/ntsb/ERA11LA175.md): Bell 206-L4 · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Mar 2, 2011 · N154MW · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN11LA207](https://openairdocs.org/ntsb/CEN11LA207.md): Cessna 310K · Angleton, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 2011 · N3816X · Destroyed
  > The pilot's failure to maintain control of the airplane during a night instrument approach.
- [NTSB CEN11FA201](https://openairdocs.org/ntsb/CEN11FA201.md): Cessna 421C · Connersville, IN · Accident · 1 fatal · Field investigation · Final report · Feb 24, 2011 · N3875C · Substantial damage
  > The pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.
- [NTSB ERA11CA152](https://openairdocs.org/ntsb/ERA11CA152.md): Airbus A320-232 · North Fayston, VT · Accident · Serious injuries · Data collection · Final report · Feb 19, 2011 · N706JB · No damage
  > The airplane's inadvertent encounter with turbulence during the approach, which resulted in serious injury to a flight attendant.
- [NTSB CEN11CA196](https://openairdocs.org/ntsb/CEN11CA196.md): Mooney M20K · Urbana, IL · Accident · Serious injuries · Data collection · Final report · Feb 17, 2011 · N262CP · Substantial damage
  > The pilot's failure to maintain aircraft control during the go-around.
- [NTSB CEN11FA193](https://openairdocs.org/ntsb/CEN11FA193.md): Gulfstream Aerospace GV-SP · Appleton, WI · Accident · No injuries · Field investigation · Final report · Feb 14, 2011 · N535GA · Substantial damage
  > The pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…
- [NTSB CEN11LA188](https://openairdocs.org/ntsb/CEN11LA188.md): Cessna 150G · Springdale, AR · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2011 · N3257J · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA11LA139](https://openairdocs.org/ntsb/ERA11LA139.md): Cessna 182P · Lincoln Park, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 10, 2011 · N25HD · Substantial damage
  > The pilot’s inadequate preflight inspection (removal of water contamination from the fuel system), which resulted in a total loss of engine power.
- [NTSB DCA11RA025](https://openairdocs.org/ntsb/DCA11RA025.md): Swearingen SA227 · Cork, Ireland · Accident · 6 fatal · Foreign investigation · Feb 10, 2011 · EC-ITP · Destroyed
  > On February 10, 2010, at 0950 local time, a Swearingen SA-227 Metroliner, Spanish registration EC-ITP, operated by Flightline/Manx2 Air as flight 7100, crashed after attempting a landing on runway 17 at the Cork Airport, Cork, Ireland. The flight was a…
- [NTSB WPR11FA125](https://openairdocs.org/ntsb/WPR11FA125.md): Beech 95-B55 (T42A) · San Bernardino, CA · Accident · Serious injuries · Field investigation · Final report · Feb 7, 2011 · N225DH · Substantial damage
  > The pilot did not recognize the loss of power in the right engine and did not execute the proper procedures for a go-around with one engine inoperative, likely due to increased workload. Contributing to the accident was the pilot's improper in-flight fuel…
- [NTSB ERA11CA134](https://openairdocs.org/ntsb/ERA11CA134.md): Piper PA-12 · Sebago Lake, ME · Accident · Serious injuries · Data collection · Final report · Feb 5, 2011 · N3806M · Substantial damage
  > The pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.
- [NTSB ERA11FA133](https://openairdocs.org/ntsb/ERA11FA133.md): Potez-Air Fouga CM 170 Magister · Kissimmee, FL · Accident · 2 fatal · Field investigation · Final report · Feb 2, 2011 · N415FM · Substantial damage
  > The pilot/mechanic's improper decision to continue a tight-turning landing pattern after a loss of hydraulic pressure, and his subsequent failure to maintain adequate airspeed during that pattern, which resulted in an accelerated maneuver stall. Contributing…
- [NTSB ERA11WA160](https://openairdocs.org/ntsb/ERA11WA160.md): Cessna 182 · Novo Repartimento, Brazil · Accident · 2 fatal · Foreign investigation · Jan 31, 2011 · PT-KAS · Destroyed
  > On January 31, 2011, about 1410 Universal Coordinated Time (UTC), a Cessna, 182P, Brazilian registration PT-KAS, operated by a private individual, collided with a tree during a balked landing at the Uniáo Farm, Novo Repartimento, Pará, Brazil. Visual…
- [NTSB CEN11LA164](https://openairdocs.org/ntsb/CEN11LA164.md): Cirrus Design SR22 · Bennett, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2011 · N787CB · Substantial damage
  > The pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.
- [NTSB CEN11CA163](https://openairdocs.org/ntsb/CEN11CA163.md): Mooney M20R · Cypress, TX · Accident · Minor injuries · Data collection · Final report · Jan 29, 2011 · N64FM · Substantial damage
  > The student pilot’s delayed decision to execute a go-around.
- [NTSB ERA11WA164](https://openairdocs.org/ntsb/ERA11WA164.md): Cessna 208B · Rio Branco, Brazil · Accident · No injuries · Foreign investigation · Jan 21, 2011 · PR-RMI · Substantial damage
  > On January 21, 2011, about 1735 Universal Coordinated Time (UTC), a Cessna 208B, Brazilian registration PR-RMI, operated by Carlos Madeira Aerotaxi Ltda, had an engine failure during a go-around, and made a forced landing near the Rio Branco International…
- [NTSB CEN11IA156](https://openairdocs.org/ntsb/CEN11IA156.md): Sikorsky 92 · Galliano, LA · Incident · No injuries · Incident investigation · Final report · Jan 19, 2011 · N920AL · Minor damage
  > The misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.
- [NTSB ERA11FA118](https://openairdocs.org/ntsb/ERA11FA118.md): Cessna 172S · North Myrtle Beach, SC · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2011 · N2100V · Substantial damage
  > The pilot's loss of airplane control during a missed approach due to spatial disorientation.
- [NTSB CEN11LA153](https://openairdocs.org/ntsb/CEN11LA153.md): Cessna 172A · Clarendon, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2011 · N7262T · Substantial damage
  > The pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.
- [NTSB ERA11WA121](https://openairdocs.org/ntsb/ERA11WA121.md): Beech B200 · Senador Canedo City, Brazil · Accident · 6 fatal · Foreign investigation · Jan 14, 2011 · PR-ART · Destroyed
  > On January 14, 2011, at 2010 coordinated universal time (1810 local time), a Beechcraft B200, Brazilian registration PR-ART, was destroyed when it impacted terrain near Senador Canedo City, Goias, Brazil, while approaching Santa Genoveva Airport (SBGO),…
- [NTSB ERA11WA120](https://openairdocs.org/ntsb/ERA11WA120.md): Bell 206B III · Ocho Rios, Jamaica · Accident · No injuries · Foreign investigation · Jan 14, 2011 · 6Y-JCA · Substantial damage
  > On January 14, 2011, about 1600 eastern standard time, a Bell 206B III, Jamaican registration 6Y-JCA, operated by Captain's Aviation Services Limited, was substantially damaged during a forced landing in Ocho Rios, Jamaica. The pilot and two passengers were…
- [NTSB CEN11CA154](https://openairdocs.org/ntsb/CEN11CA154.md): Powerchute Airwolf 912ULS · Alexandria, IN · Accident · Serious injuries · Data collection · Final report · Jan 14, 2011 · N4306P · Substantial damage
  > The pilot's failure to maintain clearance with trees during an initial climb following an aborted landing.
- [NTSB DCA11WA021](https://openairdocs.org/ntsb/DCA11WA021.md): Mcdonnell Douglas MD · Paris, France · Incident · No injuries · Foreign investigation · Jan 12, 2011 · No damage
  > On January 12, 2011, an Air Burkina Boeing MD-83 experienced near fuel exhaustion while attempting to land at Orly International Airport, Paris, France. During the ferry flight with landing gear down the flight crew determined that it did not have enough fuel…
- [NTSB WPR11LA119](https://openairdocs.org/ntsb/WPR11LA119.md): Czech Sportplanes Sro Dynamic · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Jan 9, 2011 · N595DY · Substantial damage
  > Inadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.
- [NTSB DCA11WA069](https://openairdocs.org/ntsb/DCA11WA069.md): Boeing 727 · Urmia, Iran · Accident · No injuries · Foreign investigation · Jan 9, 2011 · EP-IRP · Destroyed
  > On January 9, 2011, an Iran Air Boeing B727-200, registration EP-IRP, crashed during missed approach to Orumiyeh Airport (OITR), Urmia, Iran. Of the 105 passengers and crew onboard, 78 were fataly injured and 27 received serious injuries. The airplane was…
- [NTSB WPR11FA090](https://openairdocs.org/ntsb/WPR11FA090.md): Beech S35 · Chester, CA · Accident · 2 fatal · Field investigation · Final report · Jan 7, 2011 · N5866S · Substantial damage
  > The pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.
- [NTSB ERA11IA110](https://openairdocs.org/ntsb/ERA11IA110.md): Mooney M20E · St. Petersburg, FL · Incident · No injuries · Incident investigation · Final report · Jan 6, 2011 · N7828V · No damage
  > An inadequately maintained interior cockpit boot, which allowed a flashlight to fall through and subsequently jam the airplane's flight controls. Contributing to the incident was a lack of emphasis by government, industry, and advocacy groups that the…
- [NTSB ERA11FA107](https://openairdocs.org/ntsb/ERA11FA107.md): Beech 58P · Birmingham, AL · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2011 · N48TS · Substantial damage
  > The pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.
- [NTSB ERA11CA108](https://openairdocs.org/ntsb/ERA11CA108.md): Piper PA-22-150 · Thomaston, GA · Accident · No injuries · Data collection · Final report · Jan 6, 2011 · N5706D · Substantial damage
  > The mechanic's failure to install a cotter retaining pin in the throttle arm retaining nut resulting in excessive throttle play and loss of engine power control.
- [NTSB CEN11FA144](https://openairdocs.org/ntsb/CEN11FA144.md): Gates Learjet 35A · Springfield, IL · Accident · Minor injuries · Field investigation · Final report · Jan 6, 2011 · N800GP · Substantial damage
  > The pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…
- [NTSB CEN11CA147](https://openairdocs.org/ntsb/CEN11CA147.md): Pegasus 503 Sport · Cambridge, OH · Accident · Minor injuries · Data collection · Final report · Jan 5, 2011 · N456KL · Substantial damage
  > The pilot's failure to maintain clearance from trees and terrain during the landing approach.
- [NTSB CEN11CA152](https://openairdocs.org/ntsb/CEN11CA152.md): Eurocopter Deutschland MBB-BK 117 C-2 · Albert Lea, MN · Accident · No injuries · Data collection · Final report · Jan 2, 2011 · N145SM · Substantial damage
  > The pilot's inadequate preflight inspection of the engine cowling latches prior the flight, which resulted in the cowling door opening in-flight and striking the main rotor blades.
- [NTSB ERA11FA102](https://openairdocs.org/ntsb/ERA11FA102.md): Cessna 310F · Orange, MA · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2011 · N6725X · Substantial damage
  > The pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=56

## 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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=55

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