# 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 89 of 718 · 35,885 cases ## Cases, newest first - [NTSB CEN12LA532](https://openairdocs.org/ntsb/CEN12LA532.md): Cessna 177B · Evansville, IN · Accident · No injuries · Limited investigation · Final report · Aug 7, 2012 · N34283 · Substantial damage > The pilot’s loss of control due to an inaccurate attitude reference, which was caused by an impending (“in process”) failure of the bearing in the attitude indicator. - [NTSB ERA12LA507](https://openairdocs.org/ntsb/ERA12LA507.md): Aeronca 7AC · Clifford, PA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2012 · N83826 · Substantial damage > Partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA12LA498](https://openairdocs.org/ntsb/ERA12LA498.md): Embraer ERJ 170-200 LR · Hilton Head, SC · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2012 · N134HQ · No damage > The passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path. - [NTSB CEN12FA561](https://openairdocs.org/ntsb/CEN12FA561.md): Savage Air Epic LT · San Saba, TX · Accident · No injuries · Field investigation · Final report · Aug 4, 2012 · N603JS · Substantial damage > The improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation. - [NTSB CEN12FA520](https://openairdocs.org/ntsb/CEN12FA520.md): Piper PA-38-112 · Fate, TX · Accident · No injuries · Field investigation · Final report · Aug 4, 2012 · N2552C · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. - [NTSB WPR12CA342](https://openairdocs.org/ntsb/WPR12CA342.md): Piper PA18 · McNeal, AZ · Accident · Serious injuries · Data collection · Final report · Aug 2, 2012 · N2364P · Substantial damage > The pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high… - [NTSB ANC12FA083](https://openairdocs.org/ntsb/ANC12FA083.md): Piper PA-32-301 · Hoonah, AK · Accident · 1 fatal · Field investigation · Final report · Aug 2, 2012 · N8200M · Destroyed > The pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions. - [NTSB CEN12LA501](https://openairdocs.org/ntsb/CEN12LA501.md): Beech H35 · Holly Lake Ranch, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2012 · N4684D · Substantial damage > The incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power. - [NTSB WPR12LA341](https://openairdocs.org/ntsb/WPR12LA341.md): Fairchild Hiller FH-1100 · Cody, WY · Accident · No injuries · Limited investigation · Final report · Jul 31, 2012 · N5038F · Substantial damage > The failure of a tail rotor driveshaft coupling due to fatigue. - [NTSB CEN12IA502](https://openairdocs.org/ntsb/CEN12IA502.md): Boeing 737-924ER · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jul 31, 2012 · N37420 · Minor damage > An in-flight collision with a bird during descent to land, which resulted in damage to the left pitot tube and loss of airspeed information to the left and right primary flight displays (PFD). The reason for the total loss of indications on the left PFD could… - [NTSB ANC12LA080](https://openairdocs.org/ntsb/ANC12LA080.md): Cessna 182B · Gakona, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 2012 · N7150E · Substantial damage > The pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion. - [NTSB DCA12WA120](https://openairdocs.org/ntsb/DCA12WA120.md): Boeing 737 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Jul 30, 2012 · ZS-SJB · No damage > On July 30, 2012, at approximately 0920 UTC, a Boeing 737-800, registration ZS-SJB, s/n 29249, operated by South African Airways, experienced a sudden decompression approximately one hour after takeoff. The cabin oxygen masks deployed from the overhead panels… - [NTSB CEN12LA497](https://openairdocs.org/ntsb/CEN12LA497.md): Grumman Acft ENG Cor-Schweizer G-164B · Big Springs, NE · Accident · No injuries · Limited investigation · Final report · Jul 30, 2012 · N6676Q · Substantial damage > The total loss of engine power as a result of the pilot inadvertently shutting the engine off. Contributing to the accident was the modification to the engine control layout. - [NTSB CEN12LA512](https://openairdocs.org/ntsb/CEN12LA512.md): Piper PA-30 · Bragg City, MO · Accident · No injuries · Limited investigation · Final report · Jul 29, 2012 · N8121Y · Substantial damage > The pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation. - [NTSB DCA12WA135](https://openairdocs.org/ntsb/DCA12WA135.md): Agusta A109 · Jiquipilco, Mexico · Accident · 3 fatal · Foreign investigation · Jul 28, 2012 · XA-UQH · Destroyed > The Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation… - [NTSB DCA12WA117](https://openairdocs.org/ntsb/DCA12WA117.md): Boeing 757 · Linz, Austria · Incident · No injuries · Foreign investigation · Jul 28, 2012 · D-ABOK · No damage > The Austrian Civil Aviation Safety Investigation Authority (CASIA) has notified the NTSB of an accident involving a BOEING 757 airplane that occurred on July 28, 2012. The CASIA delegated the investigation to the German Federal Bureau of Aircraft Accidents… - [NTSB ERA12LA503](https://openairdocs.org/ntsb/ERA12LA503.md): Beech 95-A55 · Homerville, GA · Accident · No injuries · Limited investigation · Final report · Jul 27, 2012 · N1572S · Substantial damage > The loss of engine power due to debris within the engine-driven fuel pump. - [NTSB CEN12FA487](https://openairdocs.org/ntsb/CEN12FA487.md): Mooney M20TN · Adrian, MI · Accident · No injuries · Field investigation · Final report · Jul 27, 2012 · N411JL · Substantial damage > An initial nose-pitch-up event and out-of-trim condition, the reason for which could not be determined because the examinations of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the… - [NTSB ERA12LA474](https://openairdocs.org/ntsb/ERA12LA474.md): Piper PA-25-235 · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 2012 · N7313Z · Substantial damage > A total loss of engine power for reasons that could not be determined due to the postaccident salt water-damaged state of the engine. - [NTSB ERA12LA480](https://openairdocs.org/ntsb/ERA12LA480.md): Cessna A185F · Mapleton, ME · Accident · No injuries · Limited investigation · Final report · Jul 22, 2012 · N5168E · Substantial damage > The pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his use of an improper engine restart procedure. - [NTSB ERA12LA473](https://openairdocs.org/ntsb/ERA12LA473.md): Cirrus Design SR-22 · Pickens, SC · Accident · No injuries · Limited investigation · Final report · Jul 22, 2012 · N138CK · Substantial damage > A total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel. - [NTSB CEN12LA470](https://openairdocs.org/ntsb/CEN12LA470.md): Yamokoski William Glastar · Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2012 · N4970Y · Substantial damage > Failure of the automotive engine's reduction gearbox while in cruise flight. - [NTSB CEN12FA463](https://openairdocs.org/ntsb/CEN12FA463.md): Mooney M20E · Marked Tree, AR · Accident · Minor injuries · Field investigation · Final report · Jul 21, 2012 · N1310W · Substantial damage > The loss of engine power during cruise flight due to a malfunction of the fuel injection servo due to a damaged O-ring. - [NTSB CEN12LA460](https://openairdocs.org/ntsb/CEN12LA460.md): Chamberlain Gerald Escapade · Rutland, OH · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2012 · N3YV · Substantial damage > The pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the inadvertent stall during the pilot’s emergency landing and the pilot’s decision to continue flight in deteriorating… - [NTSB ANC12FA066](https://openairdocs.org/ntsb/ANC12FA066.md): Piper PA-32R-301 · Fairbanks, AK · Accident · 2 fatal · Field investigation · Final report · Jul 19, 2012 · N432LT · Destroyed > The noninstrument-rated pilot's decision to continue visual flight into instrument meteorological conditions likely leading to spatial disorientation, which resulted in a loss of airplane control and in-flight structural failure. - [NTSB CEN12LA455](https://openairdocs.org/ntsb/CEN12LA455.md): Cessna 175A · Shelby, IL · Accident · No injuries · Limited investigation · Final report · Jul 17, 2012 · N7003E · Substantial damage > The loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation. - [NTSB WPR12LA306](https://openairdocs.org/ntsb/WPR12LA306.md): Cessna 172N · Rockford, ID · Accident · No injuries · Limited investigation · Final report · Jul 16, 2012 · N5204K · Substantial damage > A partial loss of engine power during cruise flight due to the failure of the No. 3 cylinder exhaust valve for reasons that could not be determined due to the damage to the valve head and the missing valve stem. Contributing to the accident was the flight… - [NTSB ERA12WA457](https://openairdocs.org/ntsb/ERA12WA457.md): Beech B36TC · Nassau, Bahamas · Accident · 2 fatal · Foreign investigation · Jul 16, 2012 · N6703K · Destroyed - [NTSB CEN12WA523](https://openairdocs.org/ntsb/CEN12WA523.md): Air Tractor AT802 · San Rafael, Spain · Accident · No injuries · Foreign investigation · Jul 16, 2012 · EC-HMD · Minor damage > On July 16, 2012, about 1430 coordinated universal time, a Spanish-registered Air Tractor AT-802 airplane, EC-HMD, performed a forced landing following a loss of engine power near San Rafael, Ibiza, Spain. The pilot, the sole occupant, was not injured. The… - [NTSB WPR12FA305](https://openairdocs.org/ntsb/WPR12FA305.md): Cirrus Design SR22 · Salina, UT · Accident · 2 fatal · Field investigation · Final report · Jul 14, 2012 · N86AA · Substantial damage > The noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. - [NTSB ERA12LA452](https://openairdocs.org/ntsb/ERA12LA452.md): Aeronca 7CCM · Ocklawaha, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 2012 · N83977 · Substantial damage > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion. - [NTSB WPR12CA304](https://openairdocs.org/ntsb/WPR12CA304.md): Schempp Hirth Nimbus II · Redmond, OR · Accident · No injuries · Data collection · Final report · Jul 13, 2012 · N96132 · Substantial damage > A loss of aerodynamic lift that resulted in a forced landing on unsuitable terrain. - [NTSB WPR12WA334](https://openairdocs.org/ntsb/WPR12WA334.md): Piper PA34 · Broome, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jul 11, 2012 · VH-LCK · Substantial damage > On July 11, 2012, at 2020 universal coordinated time, a Piper PA-34-200, VH-LCK, collided with terrain near Broome, Australia. The airplane was a charter flight operating under the pertinent civil regulations of Australia. The pilot was fatally injured and… - [NTSB ERA12WA446](https://openairdocs.org/ntsb/ERA12WA446.md): Robinson R22 · Sao Paulo, Brazil · Accident · 2 fatal · Foreign investigation · Jul 11, 2012 · PT-HOL · Destroyed > On July 11, 2012, at 1300 Universal Coordinated Time (UTC), a Robinson R22 Beta, Brazilian registration PT-HOL, operated by Master Escola Aviacao Civil Ltda, was destroyed following a loss of in-flight control and collision with a building near Sao Paulo,… - [NTSB ERA12FA438](https://openairdocs.org/ntsb/ERA12FA438.md): Cirrus Design SR20 · Moscow, TN · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2012 · N764RV · Substantial damage > The non-instrument rated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation, a loss of airplane control, and subsequent impact with trees and terrain. - [NTSB ERA12LA435](https://openairdocs.org/ntsb/ERA12LA435.md): Piper PA-42 · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Jul 9, 2012 · N332SM · Substantial damage > The airplane’s encounter with a gravity-wave duct atmospheric phenomenon. - [NTSB ERA12FA433](https://openairdocs.org/ntsb/ERA12FA433.md): Piper PA-32R-300 · New Site, MS · Accident · 3 fatal · Field investigation · Final report · Jul 8, 2012 · N4386F · Substantial damage > The pilot's decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane. - [NTSB CEN12LA424](https://openairdocs.org/ntsb/CEN12LA424.md): Bellanca 7GCAA · Bedford, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2012 · N8733V · Substantial damage > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to return home. - [NTSB ANC12CA070](https://openairdocs.org/ntsb/ANC12CA070.md): Dehavilland DHC-2 · Cantwell, AK · Accident · No injuries · Data collection · Final report · Jul 8, 2012 · N906JS · Substantial damage > The right seat passenger’s inadvertent contact with the emergency fuel shutoff valve, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to provide a thorough preflight briefing to the… - [NTSB ANC12LA068](https://openairdocs.org/ntsb/ANC12LA068.md): Shorey Timothy A Preceptor Stol King · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 2012 · N919WP · Substantial damage > A total loss of engine power due to a binding drive belt while in the airport traffic pattern. - [NTSB ERA12LA432](https://openairdocs.org/ntsb/ERA12LA432.md): Piel Emeraude · Banner Elk, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 2012 · C-FBZZ · Substantial damage > The total loss of engine power for reasons that could not be determined because the engine was not examined. - [NTSB WPR12CA294](https://openairdocs.org/ntsb/WPR12CA294.md): Omlin Robert G Exec 162F Rotorway · Quincy, WA · Accident · No injuries · Data collection · Final report · Jul 5, 2012 · N385AR · Substantial damage > The pilot’s failure to ensure that a flag attached to the landing skid was properly secured, which resulted in its in-flight separation and contact with the tail rotor. - [NTSB DCA12WA109](https://openairdocs.org/ntsb/DCA12WA109.md): Boeing 777-222 · Narita, Japan · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · N224UA · No damage - [NTSB DCA12WA108](https://openairdocs.org/ntsb/DCA12WA108.md): Boeing 747-400 · Tokyo, Japan · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · HL7473 · No damage > On July 5, 2012, a Boeing 747-400, HL7473, operated by Korean Air Lines Co., Ltd., as flight KAL2711, departed from the Gimpo International Airport (GMP), Seoul, South Korea, en route to the Tokyo International Airport (HND), Tokyo, Japan. Approximately 100… - [NTSB DCA12WA104](https://openairdocs.org/ntsb/DCA12WA104.md): Boeing 737 · Frankfurt, Germany · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · D-ASXE · No damage > On 5 July, 2012, at approximately 1100 UTC, a SunExpress Deutschland B737-800, registration D-ASXE, encountered turbulence during cruise between Gaziantep, Turkey, and Frankfurt, Germany. Of the 86 passengers and crew onboard, one crew member received serious… - [NTSB ERA12WA444](https://openairdocs.org/ntsb/ERA12WA444.md): Lancair · Concepcio, Argentina · Accident · 2 fatal · Foreign investigation · Jul 3, 2012 · LV-X243 · Substantial damage > On July 3, 2012, about 1230 coordinated universal time (0930 local time), a Lancair IV-P, Argentine registration LV-X243, was substantially damaged when it impacted terrain in Concepcion, Corrientes Province, Argentina. The pilot and the passenger were… - [NTSB DCA12WA107](https://openairdocs.org/ntsb/DCA12WA107.md): Boeing 777 · Urumqi, China · Incident · No injuries · Foreign investigation · Jul 2, 2012 · A6-EGQ · No damage > The Civil Aviation Authority of China (CAAC) has notified the NTSB of an incident involving a Boeing 777-300 that occurred on July 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC investigation under the provisions of ICAO… - [NTSB ERA12LA428](https://openairdocs.org/ntsb/ERA12LA428.md): Cessna R172K · Greene, NY · Accident · No injuries · Limited investigation · Final report · Jul 1, 2012 · N758JQ · Substantial damage > An undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test, resulting in separation of the head from the barrel and a subsequent partial loss of engine… - [NTSB CEN12LA414](https://openairdocs.org/ntsb/CEN12LA414.md): Cessna 172S · Glenwood Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2012 · N917SA · Substantial damage > The pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in… - [NTSB CEN12LA401](https://openairdocs.org/ntsb/CEN12LA401.md): Piper PA-23 · Baltic, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2012 · N3170P · Substantial damage > Loss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=90 ## 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=89 --- 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.