# Final NTSB investigations: Standing

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 1 of 41 · 2,019 cases

## Latest cases

- [NTSB ERA26LA297](https://openairdocs.org/ntsb/ERA26LA297.md): Cessna 172N · Morgantown, WV · Accident · No injuries · Class 4 · Limited · Final report · Aug 9, 2026 · N6175G · Substantial damage
  > The fuel truck driver’s distraction and inadequate visual lookout, which resulted in a collision with an airplane.
- [NTSB ERA26LA264](https://openairdocs.org/ntsb/ERA26LA264.md): Cessna 172 · Greensboro, NC · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2026 · N7764G · Substantial damage
  > The flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.
- [NTSB ERA26LA194](https://openairdocs.org/ntsb/ERA26LA194.md): Bell Helicopter Textron Canada 206L-4 · Chapmansboro, TN · Accident · No injuries · Class 4 · Limited · Final report · Apr 30, 2026 · N409AE · Substantial damage
  > Failure of the volunteer fire department personnel to properly monitor and secure a stretcher, which resulted in it rolling into the helicopter’s tail rotor.
- [NTSB WPR26LA092](https://openairdocs.org/ntsb/WPR26LA092.md): Piper PA-28-181 · Scottsdale, AZ · Accident · No injuries · Class 4 · Limited · Final report · Jan 21, 2026 · N505AF · Substantial damage
  > The student pilot’s failure to properly adjust their seat and failure to set the parking brake before engine start, which resulted in a collision with parked vehicles.
- [NTSB CEN26LA091](https://openairdocs.org/ntsb/CEN26LA091.md): Bellanca 17-30A · Burnet, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 15, 2026 · N8213R · Substantial damage
  > The pilot’s improper judgement to relinquish his pilot responsibilities to the passenger with the engine operating, which resulted in a loss of airplane control and impact with a parked vehicle.
- [NTSB CEN26LA076](https://openairdocs.org/ntsb/CEN26LA076.md): Nanchang China CJ-6A · Burnet, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 31, 2025 · N559TX · Substantial damage
  > The pilot’s failure to secure the airplane before hand-propping the engine, which resulted in the airplane’s unexpected movement and subsequent impact with an airport fence.
- [NTSB WPR26LA042](https://openairdocs.org/ntsb/WPR26LA042.md): Cessna 150 · Marana, AZ · Accident · No injuries · Class 4 · Limited · Final report · Nov 9, 2025 · N6495T · Substantial damage
  > The pilot’s improper starting procedure which resulted in the airplane’s unexpected movement and subsequent impact with an airport fence.
- [NTSB CEN25LA399](https://openairdocs.org/ntsb/CEN25LA399.md): Vans RV9 · Stephenville, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 28, 2025 · N26AJ · Substantial damage
  > The pilot’s failure to ensure the canopy and the cockpit were properly secured during the hand prop sequence.
- [NTSB DCA25LA308](https://openairdocs.org/ntsb/DCA25LA308.md): Airbus Canada BD500 · Denver, CO · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 31, 2025 · C-GYLQ · No damage
  > Unidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.
- [NTSB CEN25LA337](https://openairdocs.org/ntsb/CEN25LA337.md): Bell OH-58A · Caseville, MI · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 23, 2025 · N707EE · Substantial damage
  > The front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.
- [NTSB ANC25LA097](https://openairdocs.org/ntsb/ANC25LA097.md): Airbus Helicopters AS350B3e · Skwentna, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 20, 2025 · N589SH · Substantial damage
  > The pilot’s inadvertent entanglement of a lightweight Kevlar long line into the helicopters operating main rotor system, resulting in a severe imbalance and separation of the main rotor gearbox.
- [NTSB DCA25LA268](https://openairdocs.org/ntsb/DCA25LA268.md): Airbus Industrie A319-131 · Santa Barbara, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 19, 2025 · N822UA · No damage
  > The ramp worker’s premature entry into the jet blast hazard area of an operating engine due to his failure to maintain situational awareness and his misinterpretation of the marshaller’s hand signals.
- [NTSB CEN25LA243](https://openairdocs.org/ntsb/CEN25LA243.md): Stinson 108 · Seguin, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 8, 2025 · N97577 · No damage
  > The pilot’s failure to turn off the magneto switch before repositioning the propeller by hand which resulted in an inadvertent engine start.
- [NTSB ERA25LA242](https://openairdocs.org/ntsb/ERA25LA242.md): Cessna 182 · Nahunta, GA · Accident · No injuries · Class 3 · Limited · Final report · Jun 26, 2025 · N4953N · Substantial damage
  > The pilot’s decision to fly an unairworthy airplane, which resulted in fire due to an unsecured carburetor bowl drain plug.
- [NTSB DCA25LA185](https://openairdocs.org/ntsb/DCA25LA185.md): Boeing 737 · Houston, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 17, 2025 · N7724A · No damage
  > Serious Injury to a flight attendant sustained during an evacuation.
- [NTSB WPR25LA091](https://openairdocs.org/ntsb/WPR25LA091.md): Cessna 182N · Auburn, CA · Accident · No injuries · Class 4 · Limited · Final report · Feb 9, 2025 · N92467 · Substantial damage
  > The pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.
- [NTSB DCA25LA117](https://openairdocs.org/ntsb/DCA25LA117.md): Boeing 737-832 · Seattle, WA · Accident · No injuries · Class 4 · Limited · Final report · Feb 5, 2025 · N3737C · 2 aircraft · Substantial damage
  > The Japan Airlines flight crew’s failure to maintain adequate clearance from the parked Delta Air Lines aircraft while taxiing in congested ramp conditions.
- [NTSB DCA25LA084](https://openairdocs.org/ntsb/DCA25LA084.md): Boeing 757 · Atlanta, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 10, 2025 · N589NW · Minor damage
  > Substantial injury to a passenger sustained during evacuation.
- [NTSB CEN25LA072](https://openairdocs.org/ntsb/CEN25LA072.md): Cessna 182H · Harvard, IL · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 8, 2025 · N1935V · Substantial damage
  > The pilot’s failure to control the airplane during the engine start which resulted in a collision with the hangar.
- [NTSB CEN25LA063](https://openairdocs.org/ntsb/CEN25LA063.md): Robinson Helicopter R22 Beta · Springfield, MO · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 21, 2024 · N3104U · Destroyed
  > The student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.
- [NTSB ANC25LA011](https://openairdocs.org/ntsb/ANC25LA011.md): Raytheon C90A · Honolulu, HI · Accident · No injuries · Class 3 · Limited · Final report · Dec 21, 2024 · N438CA · Substantial damage
  > A temporary reduction in the airplane’s braking effectiveness during engine start following an exterior wash, which resulted in its uncommanded forward movement and collision with a parked airplane. Contributing to the accident was the flight crew’s delayed…
- [NTSB ERA25LA077](https://openairdocs.org/ntsb/ERA25LA077.md): Wolstenholme Dennis Pietenpol AIR Camper · Tullahoma, TN · Accident · No injuries · Class 4 · Limited · Final report · Dec 12, 2024 · N161DW · Substantial damage
  > The pilot’s failure to adequately secure the airplane before hand-propping the engine. Contributing was the pilot’s lack of training in hand-propping procedures.
- [NTSB WPR24LA318](https://openairdocs.org/ntsb/WPR24LA318.md): Cessna 172S · Seattle, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 21, 2024 · N513WF · 2 aircraft · Substantial damage
  > The Gulfstream pilot’s failure to maintain clearance from the Cessna while taxiing that resulted in a ground collision.
- [NTSB CEN24LA308](https://openairdocs.org/ntsb/CEN24LA308.md): Cirrus Design SR22T · Tulsa, OK · Incident · No injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N825JC · Substantial damage
  > The mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.
- [NTSB CEN24LA196](https://openairdocs.org/ntsb/CEN24LA196.md): Piper PA28 · New Century, KS · Accident · No injuries · Class 4 · Limited · Final report · May 11, 2024 · N3574C · 2 aircraft · Substantial damage
  > The inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.
- [NTSB ERA24LA142](https://openairdocs.org/ntsb/ERA24LA142.md): Piper J3C-65 · Homosassa Springs, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 14, 2024 · N71093 · Substantial damage
  > The pilot’s failure to confirm the throttle position before attempting to start the airplane’s engine by manually rotating the propeller, which resulted in a loss of airplane control.
- [NTSB ENG24LA012](https://openairdocs.org/ntsb/ENG24LA012.md): British Aerospace BAE 146 Series 200A · Missoula, MT · Incident · Class 3 · Limited · Final report · Mar 1, 2024 · N474NA · 2 aircraft · Minor damage
  > The use of a new long term fire retardant with a chemical composition incompatible with the retardant previously in use for the integration-operational field evaluation without adequate testing and qualification.
- [NTSB DCA24LA092](https://openairdocs.org/ntsb/DCA24LA092.md): Airbus A321-231 · Boston, MA · Accident · No injuries · Class 4 · Limited · Final report · Feb 8, 2024 · N956JT · 2 aircraft · Substantial damage
  > The “follow me” driver stopping the airplane (flight 551) about 35 feet from the normal stopping point due to a difficulty in seeing the yellow “T”-bar because of the dark night conditions and the presence of de-icing fluid on the ground.
- [NTSB CEN24FA046](https://openairdocs.org/ntsb/CEN24FA046.md): Socata TBM 700 · Ludington, MI · Accident · 2 fatal · Class 3 · Field · Final report · Nov 26, 2023 · N850JH · Destroyed
  > The pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA23LA315](https://openairdocs.org/ntsb/ERA23LA315.md): Head Balloons AX8-88 · Guilford, CT · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 24, 2023 · N4522E · No damage
  > The pilot’s inadequate supervision of the boarding process and the ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb.
- [NTSB CEN23LA301](https://openairdocs.org/ntsb/CEN23LA301.md): Schweizer 269C-1 · Titusville, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 10, 2023 · N21409 · Substantial damage
  > The student pilot’s failure to maintain helicopter control while on the ground when his attention was diverted for post flight activities.
- [NTSB WPR23LA207](https://openairdocs.org/ntsb/WPR23LA207.md): Cessna 182Q · Kingman, AZ · Accident · Serious injuries · Class 4 · Limited · Final report · May 26, 2023 · N94599 · Minor damage
  > The failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.
- [NTSB CEN23FA183](https://openairdocs.org/ntsb/CEN23FA183.md): Robinson R22 Beta · Brady, TX · Incident · 1 fatal · Class 3 · Field · Final report · May 14, 2023 · N40506 · Substantial damage
  > The non-certificated pilot’s failure to ensure the collective friction control was adequately engaged during an on-ground engine run, which resulted in the helicopter inadvertently becoming airborne. Contributing to the crash were the pilot’s various physical…
- [NTSB CEN23LA186](https://openairdocs.org/ntsb/CEN23LA186.md): Beech F33A · Tahlequah, OK · Accident · Serious injuries · Class 4 · Limited · Final report · May 6, 2023 · N2294L · Minor damage
  > The pilot’s failure to remove the wheel chocks before engine start which resulted in the inadvertent contact with the propeller while the engine was running.
- [NTSB DCA23LA191](https://openairdocs.org/ntsb/DCA23LA191.md): Embraer ERJ 190-100 IGW · New York, NY · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 25, 2023 · N337JB · No damage
  > Electrical sparking caused by a faulty connection between the aircraft and ground power unit resulting in a serious injury to a ground service agent.
- [NTSB ERA23LA118](https://openairdocs.org/ntsb/ERA23LA118.md): Piper PA28 · Raleigh/Durham, NC · Accident · No injuries · Class 4 · Limited · Final report · Jan 23, 2023 · N747PK · Substantial damage
  > The pilot's flooding the engine with fuel during a cold engine start, which resulted in an engine fire.
- [NTSB DCA23LA109](https://openairdocs.org/ntsb/DCA23LA109.md): Embraer S A ERJ 170-200 LR · Montgomery, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 31, 2022 · N264NN · Minor damage
  > The ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…
- [NTSB WPR23LA100](https://openairdocs.org/ntsb/WPR23LA100.md): Aeronca 65-CA · Deming, NM · Accident · No injuries · Class 4 · Limited · Final report · Dec 15, 2022 · N29447 · Substantial damage
  > The occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.
- [NTSB ERA23LA085](https://openairdocs.org/ntsb/ERA23LA085.md): Cessna 172 · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · Dec 12, 2022 · N783SF · Substantial damage
  > The pilot’s loss of directional control during engine start.
- [NTSB ERA23LA065](https://openairdocs.org/ntsb/ERA23LA065.md): Piper PA-28-181 · Manassas, VA · Accident · No injuries · Class 3 · Limited · Final report · Nov 18, 2022 · N8129M · Substantial damage
  > An engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.
- [NTSB ERA23LA055](https://openairdocs.org/ntsb/ERA23LA055.md): Piper PA-28-140 · Allentown, PA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 9, 2022 · N8543E · No damage
  > The flight instructor’s decision to remove the nosewheel chock while the engine was still operating.
- [NTSB CEN23LA023](https://openairdocs.org/ntsb/CEN23LA023.md): Stephen J Hoffman MS-500 · Houston, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 29, 2022 · N778MS · Substantial damage
  > The pilot’s failure to secure the magneto switch before attempting to hand rotate the engine which resulted in an inadvertent engine start, a runaway airplane, and subsequent impact with parked airplanes. Contributing to the accident was the failure to…
- [NTSB ERA23LA022](https://openairdocs.org/ntsb/ERA23LA022.md): Cessna 172S · Statesboro, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 17, 2022 · N2476Y · No damage
  > The pilot’s failure to include deplaning procedures as part of a passenger safety briefing and failure to have the passengers remain onboard until the engine was shut down, which resulted in a passenger subsequently being struck by the rotating propeller.
- [NTSB ERA22LA362](https://openairdocs.org/ntsb/ERA22LA362.md): Diamond DA-40 · Bardstown, KY · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 7, 2022 · N723AG · Minor damage
  > The pilot’s failure to provide adequate instructions to remain seated until the engine was shut down, which resulted in the passenger’s decision to exit the cockpit while the engine was operating and subsequently being struck by the rotating propeller.
- [NTSB ERA22LA328](https://openairdocs.org/ntsb/ERA22LA328.md): Robinson Helicopter R22 Beta · Orlando, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 17, 2022 · N224MG · Substantial damage
  > The flight instructor’s inadequate remedial actions following the student pilot’s improper control inputs, which resulted in dynamic rollover.
- [NTSB ERA22LA229](https://openairdocs.org/ntsb/ERA22LA229.md): Messerschmitt-Bolkow-Blohm BK 117 B-2 · Rochester, NY · Accident · No injuries · Class 3 · Limited · Final report · May 14, 2022 · N370SS · Substantial damage
  > An unintentional movement of the cyclic control before takeoff, which resulted the main rotor blades contacting the fixed wire cutter.
- [NTSB WPR22LA146](https://openairdocs.org/ntsb/WPR22LA146.md): Robinson Helicopter R22 · Phoenix, AZ · Accident · No injuries · Class 4 · Limited · Final report · Apr 7, 2022 · N19VH · Substantial damage
  > The pilot’s failure to maintain helicopter control while on the ground when his attention was diverted, which resulted in a dynamic rollover.
- [NTSB CEN22LA167](https://openairdocs.org/ntsb/CEN22LA167.md): Robinson Helicopter R22 · Hawley, TX · Accident · No injuries · Class 4 · Limited · Final report · Apr 5, 2022 · N999FR · Substantial damage
  > The pilot’s poor decision to exit the helicopter with the engine and main rotor still operating.
- [NTSB ERA22LA115](https://openairdocs.org/ntsb/ERA22LA115.md): Pilatus PC-12/47E · Ronkonkoma, NY · Accident · No injuries · Class 3 · Limited · Final report · Feb 2, 2022 · N357JK · Substantial damage
  > The pilot’s failure to properly position the power control lever before starting the engine as required per the checklist. Contributing to the accident were the ice on the ramp and the pilot’s failure to secure the engine using the condition lever.
- [NTSB ERA21LA387](https://openairdocs.org/ntsb/ERA21LA387.md): Robinson Helicopter R44 II · Miami, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 28, 2021 · N212HT · Substantial damage
  > The pilot’s loss of helicopter control after landing. Also causal was the pilot’s intentional operation of the helicopter without the required training, experience, and endorsements.

Next page: https://openairdocs.org/ntsb-phases/150/cases.md?status=final&page=2

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?status=final

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