# 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 46 of 718 · 35,883 cases ## Cases, newest first - [NTSB WPR19LA273](https://openairdocs.org/ntsb/WPR19LA273.md): Smyth Sidewinder · Tucumcari, NM · Accident · No injuries · Class 3 · Limited · Final report · Sep 14, 2019 · N492AC · Substantial damage > The in-flight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing. - [NTSB CEN19LA331](https://openairdocs.org/ntsb/CEN19LA331.md): Cirrus SR20 · Orange, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 14, 2019 · N200Z · Substantial damage > A total loss of engine power due to a fatigue failure of the fuel line from the fuel manifold to the No. 1 cylinder. - [NTSB CEN19LA320](https://openairdocs.org/ntsb/CEN19LA320.md): Cirrus SR22 · Hoagland, IN · Accident · Minor injuries · Class 2 · Limited · Final report · Sep 13, 2019 · N578SP · Substantial damage > A catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance… - [NTSB WPR19LA255](https://openairdocs.org/ntsb/WPR19LA255.md): Sikorsky S58 · Azusa, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 11, 2019 · N1168U · Substantial damage > The in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field. - [NTSB DCA19WA216](https://openairdocs.org/ntsb/DCA19WA216.md): Airbus A321 · Nassau, Bahamas · Incident · No injuries · Foreign investigation · Sep 11, 2019 · N958JB · No damage > The government of Bahamas has notified the NTSB of an accident involving a Airbus A321 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the… - [NTSB GAA19WA553](https://openairdocs.org/ntsb/GAA19WA553.md): Cessna 208 · Gransee, Germany · Accident · 1 fatal · Foreign investigation · Sep 9, 2019 · D-FIDI · Destroyed > The government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the… - [NTSB CEN19LA308](https://openairdocs.org/ntsb/CEN19LA308.md): Cessna 150 · Whitehall, MI · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 9, 2019 · N9492U · Destroyed > The pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation. - [NTSB WPR19FA256](https://openairdocs.org/ntsb/WPR19FA256.md): Piper PA32 · La Grande, OR · Accident · 1 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N6300Z · Destroyed > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control. - [NTSB CEN19FA307](https://openairdocs.org/ntsb/CEN19FA307.md): Cessna 140 · Lakeview, SD · Accident · 2 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N73000 · Substantial damage > The student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of… - [NTSB CEN19FA305](https://openairdocs.org/ntsb/CEN19FA305.md): Champion 7GCBC · Carpenter, WY · Accident · 1 fatal · Class 3 · Field · Final report · Sep 7, 2019 · N5502S · Destroyed > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery. - [NTSB DCA19CA213](https://openairdocs.org/ntsb/DCA19CA213.md): Airbus A319 · Fort Myers, FL · Accident · Serious injuries · Class 4 · Data collection · Final report · Sep 6, 2019 · N515NK · No damage > an encounter with convectively induced turbulence associated with towering cumulus clouds during descent. - [NTSB GAA19WA593](https://openairdocs.org/ntsb/GAA19WA593.md): Piper PA25 · Mazatan, Chiapas, Mexico · Accident · No injuries · Foreign investigation · Sep 5, 2019 · XB-LED > The government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions… - [NTSB GAA19WA565](https://openairdocs.org/ntsb/GAA19WA565.md): Cessna 172 · Racine, Canada · Accident · 1 fatal · Foreign investigation · Sep 5, 2019 · C-GSEN · Destroyed > The government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO… - [NTSB CEN19LA303](https://openairdocs.org/ntsb/CEN19LA303.md): Phantom Aeronautics X-1 · Van Wert, OH · Accident · No injuries · Class 3 · Limited · Final report · Sep 4, 2019 · N111JC · Substantial damage > A loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer. - [NTSB GAA19CA534](https://openairdocs.org/ntsb/GAA19CA534.md): Piper PA28 · Sawyer, MI · Accident · No injuries · Data collection · Final report · Sep 3, 2019 · N2909U · Substantial damage > The pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss… - [NTSB CEN19LA313](https://openairdocs.org/ntsb/CEN19LA313.md): Jackson Velocity · Mack, CO · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2019 · N2XF · Substantial damage > A propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing. - [NTSB DCA19WA212](https://openairdocs.org/ntsb/DCA19WA212.md): Boeing 737 · South Africa · Incident · No injuries · Foreign investigation · Sep 2, 2019 · ZS-SJD · No damage > The government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the… - [NTSB CEN19LA319](https://openairdocs.org/ntsb/CEN19LA319.md): Lancair LC41-550FG · Branson, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 2, 2019 · N405JA · Substantial damage > A total loss of engine power after takeoff for undetermined reasons. - [NTSB ERA19LA264](https://openairdocs.org/ntsb/ERA19LA264.md): Cirrus SR22 · Foley, AL · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2019 · N878SR · Substantial damage > Total loss of engine power due to a fatigue failure of the camshaft gear. - [NTSB GAA19WA594](https://openairdocs.org/ntsb/GAA19WA594.md): Airbus A350 · Alta city, Norway · Accident · 1 fatal · Foreign investigation · Aug 31, 2019 · LN-OFU · Destroyed > The government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions… - [NTSB ANC19LA048](https://openairdocs.org/ntsb/ANC19LA048.md): Piper PA-18 · Fairbanks, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 30, 2019 · N1124 · Substantial damage > The inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power. - [NTSB WPR19WA260](https://openairdocs.org/ntsb/WPR19WA260.md): Air Tractor AT502 · Gusap, Papua New Guinea · Accident · 1 fatal · Foreign investigation · Aug 29, 2019 · P2-SET · Destroyed > On August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)… - [NTSB ENG19RA033](https://openairdocs.org/ntsb/ENG19RA033.md): Saab 340 · Merimbula, Australia · Incident · No injuries · Foreign investigation · Aug 29, 2019 · VH-RXX · No damage > The Australian Transport Safety Bureau (ATSB) notified the NTSB of an incident involving a SAAB 340B airplane which occurred on August 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of… - [NTSB DCA19CA206](https://openairdocs.org/ntsb/DCA19CA206.md): Airbus A320 · Denver, CO · Accident · Serious injuries · Data collection · Final report · Aug 27, 2019 · N328FR · No damage > an encounter with mountain wave turbulence. - [NTSB CEN19LA290](https://openairdocs.org/ntsb/CEN19LA290.md): Beech V35 · Monroe, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 27, 2019 · N6245V · Substantial damage > A total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined. - [NTSB WPR19LA240](https://openairdocs.org/ntsb/WPR19LA240.md): Scoda Aeronautical Super Petrel · Lancaster, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 25, 2019 · N632MM · Substantial damage > The improper sealing of both carburetor bowls, which resulted in a total loss of engine power. - [NTSB GAA19WA540](https://openairdocs.org/ntsb/GAA19WA540.md): Robinson R44 · Buriti Alegre, Brazil · Accident · 3 fatal · Foreign investigation · Aug 25, 2019 · PR-APN · Destroyed > The government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions… - [NTSB CEN19WA287](https://openairdocs.org/ntsb/CEN19WA287.md): Piper PA28RT · Simplon Pass, Switzerland · Accident · 3 fatal · Foreign investigation · Aug 25, 2019 · G-BVDH · Destroyed > The government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the… - [NTSB CEN19TA293](https://openairdocs.org/ntsb/CEN19TA293.md): Piper J3C · Russiaville, IN · Accident · No injuries · Class 3 · Final report · Aug 25, 2019 · N49614 · Substantial damage > The pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing. - [NTSB DCA19WA209](https://openairdocs.org/ntsb/DCA19WA209.md): Boeing 777 · Shannon, Ireland · Incident · No injuries · Foreign investigation · Aug 24, 2019 · G-STBB · No damage > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex… - [NTSB ERA19LA258](https://openairdocs.org/ntsb/ERA19LA258.md): Beech F33 · Hobe Sound, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 23, 2019 · N80WH · Substantial damage > A bearing shift, which resulted in a loss of lubrication to the crankshaft, the failure of the crankshaft, and a total loss of engine power. - [NTSB ERA19LA257](https://openairdocs.org/ntsb/ERA19LA257.md): Cirrus SR22 · Burnsville, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 22, 2019 · N404PE · Substantial damage > The pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic… - [NTSB WPR19LA238](https://openairdocs.org/ntsb/WPR19LA238.md): Beech 36 · Half Moon Bay, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 21, 2019 · N134P · Destroyed > A total loss of engine power for reasons that could not be determined. - [NTSB ERA19LA253](https://openairdocs.org/ntsb/ERA19LA253.md): Velocity XL-5 · St. Cloud, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 21, 2019 · N735D · Substantial damage > The pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight. - [NTSB ERA19WA261](https://openairdocs.org/ntsb/ERA19WA261.md): Agusta A109 · Poros, Greece · Accident · 3 fatal · Foreign investigation · Aug 20, 2019 · SX-HTO · Substantial damage > The government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's… - [NTSB ERA19LA252](https://openairdocs.org/ntsb/ERA19LA252.md): Piper PA 31P · East Brady, PA · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2019 · N90AP · Substantial damage > A total loss of left engine power for undetermined reasons. - [NTSB DCA19WA217](https://openairdocs.org/ntsb/DCA19WA217.md): Boeing 737 · Cape Town, South Africa · Incident · No injuries · Foreign investigation · Aug 20, 2019 · ZS-JRM · Minor damage > The CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of… - [NTSB ERA19FA251](https://openairdocs.org/ntsb/ERA19FA251.md): Cirrus SR22 · Tappahannock, VA · Accident · Serious injuries · Field investigation · Final report · Aug 19, 2019 · N621JE · Substantial damage > The pilot's inability to land on the runway in dark night conditions with reported smoke in the cockpit, which necessitated the deployment of the airplane's parachute system. - [NTSB CEN19FA271](https://openairdocs.org/ntsb/CEN19FA271.md): Cessna U206 · Hopedale, LA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 18, 2019 · N5364Q · Destroyed > The controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions. - [NTSB ERA19TA254](https://openairdocs.org/ntsb/ERA19TA254.md): GIger Frank R Nieuport II · Talladega, AL · Accident · Minor injuries · Class 3 · Final report · Aug 17, 2019 · N112GV · Substantial damage > A total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees. - [NTSB ENG19WA032](https://openairdocs.org/ntsb/ENG19WA032.md): Airbus A320 · Nassau, Bahamas · Incident · No injuries · Foreign investigation · Aug 17, 2019 · N335NW · No damage > The Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions… - [NTSB CEN19WA341](https://openairdocs.org/ntsb/CEN19WA341.md): Cessna 150 · Ravna Gora, Croatia · Accident · No injuries · Foreign investigation · Aug 17, 2019 · 9A-DMI · No damage > The government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions… - [NTSB GAA19CA495](https://openairdocs.org/ntsb/GAA19CA495.md): Flight Design CT2K · Hooper, WA · Accident · Minor injuries · Data collection · Final report · Aug 16, 2019 · N433CT · Substantial damage > The pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over. - [NTSB DCA19WA203](https://openairdocs.org/ntsb/DCA19WA203.md): Boeing 787 · Beijing, China · Accident · Serious injuries · Foreign investigation · Aug 15, 2019 · JA808A · No damage > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex… - [NTSB CEN19LA275](https://openairdocs.org/ntsb/CEN19LA275.md): Cessna 150 · Rio Grande City, TX · Accident · No injuries · Class 3 · Limited · Final report · Aug 15, 2019 · N150CR · Substantial damage > The loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain. - [NTSB WPR19FA216](https://openairdocs.org/ntsb/WPR19FA216.md): Lancair Lancair IV · Kooskia, ID · Accident · 2 fatal · Class 3 · Field · Final report · Aug 11, 2019 · N350CL · Substantial damage > The pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control. - [NTSB WPR21WA102](https://openairdocs.org/ntsb/WPR21WA102.md): Cessna 150 · Gan International Airport, Maldives · Accident · Class 5 · Foreign · Aug 9, 2019 · 8Q-GAC · Minor damage - [NTSB GAA19WA573](https://openairdocs.org/ntsb/GAA19WA573.md): Beech 36 · Corse-du-Sud, France · Accident · Serious injuries · Foreign investigation · Aug 9, 2019 · OO-JBM · Destroyed > The government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of… - [NTSB ENG19WA042](https://openairdocs.org/ntsb/ENG19WA042.md): Airbus A320 · Varanasi, India · Incident · No injuries · Foreign investigation · Aug 9, 2019 · VT-IZT · No damage > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 9, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)… - [NTSB ERA19WA242](https://openairdocs.org/ntsb/ERA19WA242.md): Piper PA34 · Bimini, Bahamas · Accident · No injuries · Foreign investigation · Aug 8, 2019 · N40702 · Substantial damage > The government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=47 ## 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=46 --- 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.