# NTSB investigations: Prior to flight

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 2 of 3 · 137 cases

## Cases, newest first

- [NTSB ERA20TA005](https://openairdocs.org/ntsb/ERA20TA005.md): Silverlight AR-1 · Fort Meade, FL · Accident · No injuries · Class 3 · Final report · Oct 3, 2019 · N463JW · Substantial damage
  > The student pilot’s inadequate preflight inspection that failed to detect water contamination of the fuel and resulted in a total loss of engine power during cruise flight.
- [NTSB GAA19CA549](https://openairdocs.org/ntsb/GAA19CA549.md): Cessna L19 · Kennett, MO · Accident · No injuries · Data collection · Final report · Sep 15, 2019 · N4584N · Substantial damage
  > The pilot's failure to install the engine oil filler cap before the first flight of the day; his subsequent failure to conduct a preflight check before the accident flight, which resulted in his failure to note that the cap was not installed; and his improper…
- [NTSB WPR19LA259](https://openairdocs.org/ntsb/WPR19LA259.md): Piper PA28 · Marana, AZ · Accident · No injuries · Class 3 · Limited · Final report · Sep 14, 2019 · N4403Z · Substantial damage
  > Excessive fuel pressure and temperature throughout the fuel system due to heat soaking, which resulted in an engine fire during engine start.
- [NTSB DCA19WA211](https://openairdocs.org/ntsb/DCA19WA211.md): Airbus A330 · Beijing, China · Accident · No injuries · Foreign investigation · Aug 27, 2019 · B-5958 · Substantial damage
  > The government of China has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on August 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…
- [NTSB DCA19CA186](https://openairdocs.org/ntsb/DCA19CA186.md): Boeing 757 · San Francisco, CA · Accident · No injuries · Class 4 · Data collection · Final report · Jul 23, 2019 · N57852 · Substantial damage
  > failure of the ground crew to maintain clearance from the parked airplane during pushback.
- [NTSB DCA19CA168](https://openairdocs.org/ntsb/DCA19CA168.md): Boeing 737-8H4 · Pittsburgh, PA · Accident · No injuries · Class 4 · Data collection · Final report · Jun 17, 2019 · N8608N · Substantial damage
  > a provisioning truck that impacted the airplane resulting in substantial damage.
- [NTSB DCA19WA196](https://openairdocs.org/ntsb/DCA19WA196.md): Boeing 777 · New Delhi, India · Incident · Serious injuries · Foreign investigation · Oct 15, 2018 · VT-ALN · No damage
  > The government of India has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on October 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the…
- [NTSB DCA18CA294](https://openairdocs.org/ntsb/DCA18CA294.md): Airbus A321 · Dallas, TX · Accident · Serious injuries · Data collection · Final report · Sep 26, 2018 · N994AN · No damage
  > a passenger leaving a bag in the aisle that the flight attendant tripped over.
- [NTSB DCA18CA299](https://openairdocs.org/ntsb/DCA18CA299.md): Boeing 757 · Newark, NJ · Accident · Serious injuries · Data collection · Final report · Sep 24, 2018 · N13113 · No damage
  > the catering cart striking the flight attendant's foot.
- [NTSB WPR18LA259](https://openairdocs.org/ntsb/WPR18LA259.md): Cessna 172 · Roche Harbor, WA · Accident · No injuries · Class 3 · Limited · Final report · Sep 12, 2018 · N24ME · Substantial damage
  > The pilot’s failure to secure his seat position prior to takeoff, which resulted in a loss of airplane control and subsequent hard landing.
- [NTSB GAA18CA409](https://openairdocs.org/ntsb/GAA18CA409.md): Cessna 208 · Chicago, IL · Accident · No injuries · Data collection · Final report · Jul 4, 2018 · N208EE · Substantial damage
  > The service truck driver’s evasive maneuver to avoid a bag cart tug, which resulted in the truck impacting a parked airplane.
- [NTSB ENG18RA032](https://openairdocs.org/ntsb/ENG18RA032.md): Dassault FALCON7X · Singapore, Singapore · Incident · No injuries · Foreign investigation · Jun 25, 2018 · VQ-BLP
  > The Singapore TSIB has notified the NTSB of an incident involving a Dassault Falcon 7X, VQ-BLP, which occurred on June 25, 2018. There was a fire in the mechanical service compartment while passengers were on board. The NTSB has appointed a U.S. Accredited…
- [NTSB DCA18CA209](https://openairdocs.org/ntsb/DCA18CA209.md): Boeing 737-8H4 · Phoenix, AZ · Accident · Serious injuries · Data collection · Final report · Jun 12, 2018 · N8693A · No damage
  > a passenger bumping into a flight attendant who was holding a hot liquid.
- [NTSB DCA18WA137](https://openairdocs.org/ntsb/DCA18WA137.md): Boeing 737 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Apr 5, 2018 · unknown · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB ERA18MA099](https://openairdocs.org/ntsb/ERA18MA099.md): American Eurocopter AS350B2 · New York, NY · Accident · 5 fatal · Class 1 · Major · Final report · Mar 11, 2018 · N350LH · Substantial damage
  > Liberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…
- [NTSB CEN18LA113](https://openairdocs.org/ntsb/CEN18LA113.md): Aero Commander 100-180 · Deport, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 2018 · N3733X · Substantial damage
  > A total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot/owner's inadequate maintenance of the fuel caps.
- [NTSB CEN18WA066](https://openairdocs.org/ntsb/CEN18WA066.md): Gulfstream Aerospace LP Gulfstream G150 · Kittilä, Finland · Accident · 1 fatal · Foreign investigation · Jan 5, 2018 · OE-GKA · No damage
  > On January 5, 2018, about 1200 coordinated universal time, a Gulfstream G150 airplane, OE-GKA, was involved in a ground accident that fatally injured the pilot when he was struck by the door. The accident investigation is under the jurisdiction and control of…
- [NTSB WPR18LA058](https://openairdocs.org/ntsb/WPR18LA058.md): Cessna 210 · San Bernardino, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2017 · N222AT · Substantial damage
  > The fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…
- [NTSB DCA18CA074](https://openairdocs.org/ntsb/DCA18CA074.md): Boeing 737 7H4 · Los Angeles, CA · Accident · Serious injuries · Data collection · Final report · Nov 19, 2017 · N740SW · No damage
  > The provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.
- [NTSB DCA18CA001](https://openairdocs.org/ntsb/DCA18CA001.md): Boeing 737 7H4 · Chicago, IL · Accident · No injuries · Data collection · Final report · Oct 2, 2017 · N930WN · Substantial damage
  > the mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.
- [NTSB ERA17LA333](https://openairdocs.org/ntsb/ERA17LA333.md): Buschmann/Vanzee Vari EZ · Ambler, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2017 · N830S · Substantial damage
  > Water contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.
- [NTSB GAA17CA537](https://openairdocs.org/ntsb/GAA17CA537.md): Bellanca 8GCBC · Foley, AL · Accident · No injuries · Data collection · Final report · Aug 23, 2017 · N181TM · Substantial damage
  > The ground crew’s incorrect hook up of the banner, which resulted in a nose-over.
- [NTSB CEN17LA234](https://openairdocs.org/ntsb/CEN17LA234.md): Aeronca 65 CA · Mount Vernon, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 17, 2017 · N33778 · Minor damage
  > The pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.
- [NTSB GAA17CA347](https://openairdocs.org/ntsb/GAA17CA347.md): Aeronca 11AC · Watervliet, MI · Accident · Minor injuries · Data collection · Final report · Jun 16, 2017 · N9404E · Substantial damage
  > The flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.
- [NTSB DCA17WA127](https://openairdocs.org/ntsb/DCA17WA127.md): Boeing 747 · Glasgow, United Kingdom · Incident · No injuries · Foreign investigation · Mar 30, 2017 · LX-VCF · No damage
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on March 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB CEN17LA135](https://openairdocs.org/ntsb/CEN17LA135.md): Luscombe 8F · Vicksburg, MI · Accident · 1 fatal · Limited investigation · Final report · Mar 20, 2017 · N2007B · No damage
  > The pilot's inadvertent contact with the propeller while hand propping the engine, which resulted in a fatal injury.
- [NTSB WPR17LA064](https://openairdocs.org/ntsb/WPR17LA064.md): Beech A36TC · Stevensville, MT · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 2017 · N3803J · Substantial damage
  > The pilot's decision to conduct a takeoff with a tailwind on an upsloping runway in an overweight airplane, which resulted in the airplane having insufficient energy to climb out of ground effect.
- [NTSB WPR17LA075](https://openairdocs.org/ntsb/WPR17LA075.md): Hughes 369A · (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2017 · N805LA · Substantial damage
  > The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…
- [NTSB DCA17CA072](https://openairdocs.org/ntsb/DCA17CA072.md): Boeing 737 76N · Phoenix, AZ · Accident · Serious injuries · Data collection · Final report · Feb 12, 2017 · N7822A · No damage
  > the catering agent's lack of situational awareness when exiting the airplane that resulted in a serious injury.
- [NTSB GAA17CA119](https://openairdocs.org/ntsb/GAA17CA119.md): Cessna 175 · Lakeport, CA · Accident · No injuries · Data collection · Final report · Jan 6, 2017 · N8148T · Substantial damage
  > The pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.
- [NTSB DCA17WA054](https://openairdocs.org/ntsb/DCA17WA054.md): Boeing 737 · Sydney, Australia · Incident · No injuries · Foreign investigation · Dec 17, 2016 · ZK-TLK · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…
- [NTSB DCA17WA065](https://openairdocs.org/ntsb/DCA17WA065.md): Boeing 737 · Adelaide, Australia · Incident · No injuries · Foreign investigation · Dec 12, 2016 · UNK · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the…
- [NTSB DCA16CA211](https://openairdocs.org/ntsb/DCA16CA211.md): Boeing 737 832 · New York, NY · Accident · No injuries · Data collection · Final report · Aug 10, 2016 · N3762Y · Substantial damage
  > inadvertent collision by ground service vehicle.
- [NTSB GAA16CA405](https://openairdocs.org/ntsb/GAA16CA405.md): Bell 206 · Outlook, WA · Accident · Minor injuries · Data collection · Final report · Jul 29, 2016 · N1087N · Destroyed
  > The pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.
- [NTSB CEN16FA290](https://openairdocs.org/ntsb/CEN16FA290.md): Flight Design Ctls · Fond du Lac, WI · Accident · 1 fatal · Field investigation · Final report · Jul 28, 2016 · N527TS · Substantial damage
  > Carburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.
- [NTSB DCA16WA198](https://openairdocs.org/ntsb/DCA16WA198.md): Boeing Boeing 737-8AS · Charleroi, Belgium · Accident · Serious injuries · Foreign investigation · Jul 1, 2016 · EI-ENH · No damage
  > The Air Accident Investigation Unit of Belgium has notified the NTSB of an accident involving a Boeing 737 that occurred on July 01, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under the provisions of ICAO…
- [NTSB DCA16WA191](https://openairdocs.org/ntsb/DCA16WA191.md): Airbus Industrie A330 323 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jun 26, 2016 · N276AY · No damage
  > Air Accident Investigation Branch (AAIB) notified the NTSB of a serious incident involving a AIRBUS INDUSTRIE A330 323 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…
- [NTSB GAA16CA308](https://openairdocs.org/ntsb/GAA16CA308.md): Cessna 208 · Fort Dodge, IA · Accident · No injuries · Data collection · Final report · Jun 5, 2016 · N750Z · Substantial damage
  > The flight crew's failure to install the tail stand prior to passenger boarding, which resulted in a tail strike.
- [NTSB GAA16CA162](https://openairdocs.org/ntsb/GAA16CA162.md): Piper PA24 · Homestead, FL · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N55UA · Substantial damage
  > The pilots decision to hand prop the airplane's engine without securing the airplane, resulting a runaway airplane and collision with a fence.
- [NTSB GAA16LA046](https://openairdocs.org/ntsb/GAA16LA046.md): U-Fly-It Aerolite 103 · Midland, VA · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 2015 · UNREG · Substantial damage
  > The pilot’s failure to attain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during takeoff with the airplane’s center of gravity aft of its limit, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA15CA295](https://openairdocs.org/ntsb/ERA15CA295.md): Stol JA30 Superstol · West Union, SC · Accident · No injuries · Data collection · Final report · Aug 2, 2015 · N556TW · Substantial damage
  > A loss of engine power while maneuvering due to water contamination in the fuel.
- [NTSB CEN15LA233](https://openairdocs.org/ntsb/CEN15LA233.md): Cessna T206H · Piggott, AR · Accident · Minor injuries · Limited investigation · Final report · May 15, 2015 · N164CS · Substantial damage
  > The loss of engine power due to a malfunctioning magneto. Contributing to the accident was maintenance personnel's improper use of a drill bit instead of a timing pin during magneto installation, which resulted in a section of the drill bit breaking off and…
- [NTSB GAA15CA057](https://openairdocs.org/ntsb/GAA15CA057.md): Cessna 182T · St Marys, PA · Accident · Minor injuries · Data collection · Final report · May 3, 2015 · N53310 · Substantial damage
  > The pilot's decision to rotate the propeller by hand without properly securing the airplane.
- [NTSB ERA15LA190](https://openairdocs.org/ntsb/ERA15LA190.md): Mooney M20C · Winchester, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 2015 · N9680M · Substantial damage
  > The pilot's inadequate weight and balance and performance planning, including his decision to take off with more passengers than permitted, and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an…
- [NTSB GAA15CA008](https://openairdocs.org/ntsb/GAA15CA008.md): Cessna 170A · Palmetto, FL · Accident · No injuries · Data collection · Final report · Mar 12, 2015 · N170TW · Substantial damage
  > The pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.
- [NTSB DCA15WA043](https://openairdocs.org/ntsb/DCA15WA043.md): Boeing 737-800 · London, United Kingdom · Accident · No injuries · Foreign investigation · Dec 17, 2014 · EI-EBR · Substantial damage
  > The United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 737-800 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB DCA15LA011](https://openairdocs.org/ntsb/DCA15LA011.md): Boeing 737 330 · Lanai, HI · Accident · No injuries · Limited investigation · Final report · Oct 17, 2014 · N301KH · Substantial damage
  > the improper loading and securing of the cargo pallets, which shifted on departure, resulting in substantial damage to the aft pressure bulkhead.
- [NTSB CEN14FA462](https://openairdocs.org/ntsb/CEN14FA462.md): Cessna 421C · Las Cruces, NM · Accident · 4 fatal · Field investigation · Final report · Aug 28, 2014 · N51RX · Destroyed
  > The misfueling of the airplane with jet fuel instead of the required aviation fuel, and the resultant detonation and a total loss of engine power during initial climb. Contributing to the accident were the line service technician's inadvertent misfueling of…
- [NTSB ERA14CA397](https://openairdocs.org/ntsb/ERA14CA397.md): Raytheon G36 · Milton, FL · Accident · Minor injuries · Data collection · Final report · Aug 20, 2014 · N636TM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in an attempted takeoff over the airplane's maximum gross weight and beyond its aft center of gravity limit. Contributing to the accident was the pilot's lack of total flight experience in the aircraft…
- [NTSB ERA14FA343](https://openairdocs.org/ntsb/ERA14FA343.md): Piper PA-32R-301T · North Captiva Island, FL · Accident · 1 fatal · Field investigation · Final report · Jul 16, 2014 · N297AS · Substantial damage
  > The pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…

Next page: https://openairdocs.org/ntsb-phases/100/cases.md?page=3

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

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

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