NTSB investigations

35,885 cases where the phase of flight was Enroute.

Cases, newest first

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Madera, CADuring a dual instructional flight, the pilots were practicing a simulated engine out procedure. Engine power had been reduced to 15' of manifold pressure. When an attempt was made to add power at an altitude of about 500 ft, the engine quit. The instructor…Oct 23, 1986 · N2853X · Substantial damageNTSB DEN87FA008Accident · 1 fatalField investigationFinal reportMooney M20B · Buffalo, WYAt aprx 1720 MDT, tower psnl at the dep arpt received a phone call from the plt. He said he wished to depart with an inop 2-WAY radio. He was advised that IMC prevailed & that a radio would be required to depart with an IFR or special VFR clnc. At 1907 (after…Oct 23, 1986 · N74739 · DestroyedNTSB ATL87FA009Accident · Minor injuriesField investigationFinal reportBell 206B III · Nashville, TNThe plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…Oct 20, 1986 · N2204Z · Substantial damageNTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…Oct 19, 1986 · N5094K · Substantial damageNTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…Oct 19, 1986 · N8449X · Substantial damageNTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…Oct 19, 1986 · N69223 · Substantial damageNTSB LAX87MA018Accident · 2 fatalMajor investigationFinal reportCessna 172N · Altadena, CAWhile rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…Oct 17, 1986 · N1048F · DestroyedNTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…Oct 16, 1986 · N95354 · Substantial damageNTSB LAX87FA016Accident · No injuriesField investigationFinal reportBeech K35 · Bakersfield, CAThe flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated the…Oct 15, 1986 · N107Q · Substantial damageNTSB SEA87LA029Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mountain Home, IDOn short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…Oct 14, 1986 · N94529 · Substantial damageNTSB SEA87LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Perrydale, ORThe acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.Oct 14, 1986 · N8184F · DestroyedNTSB MIA87LA006Accident · No injuriesLimited investigationFinal reportCessna U206F · Caribbean SeaThe acft was destroyed upon ditching in the ocean after sustaining eng failure several minutes after takeoff. The plt stated that he checked the fuel tanks with a calibrated dip-stick and determined there was 20 gals of fuel in the left tank and 15 gals in…Oct 14, 1986 · N8147Q · DestroyedNTSB NYC87DNC02Accident · No injuriesFinal reportCessna 172M · Van Buren, MEWhile climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…Oct 13, 1986 · N5255R · Substantial damageNTSB ATL87FA042Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pell City, ALThe aircraft departed albany Georgia for fenton Missouri without a flight plan. VFR not recommended had been given to the commercial, CFI, instrument rated pilot twice during the day. The wreckage was found two months later on the side of a mountain in…Oct 13, 1986 · N4576R · DestroyedNTSB LAX87LA015Accident · No injuriesLimited investigationFinal reportCessna 182A · King City, CAWhile cruising near King City, CA, the aircraft lost power and an attempt to restart the engine was unsuccessful. The aircraft was then landed in a field, but it collided with a tree during the landing roll. An examination of the aircraft revealed that the…Oct 12, 1986 · N4823D · Substantial damageNTSB NYC87LA017Accident · No injuriesLimited investigationFinal reportCessna C-152 · Port Jefferson, NYThe Cessna 152 experienced a total loss of power for unknown reason while leveling off at 1800 ft. the student pilot escaped without injury from the aircraft after it was ditched in long island sound. The aircraft was not recovered.Oct 11, 1986 · N67903 · Substantial damageNTSB NYC87DNC01Accident · No injuriesFinal reportEnstrom F-28A · Belmont, NHThe helicopter was in cruise flt when an engine failure occurred. The plt entered an autorotation and made a hard landing which collapsed the left front strut. The nose lowered as the tail cone rose and the main rotor made contact with the tail rotor. The…Oct 11, 1986 · N238Q · Substantial damageNTSB LAX87FA014Accident · 2 fatalField investigationFinal reportCessna 177RG · Happy Jack, AZThe non-instrument rated private plt was informed that MVFR weather conditions existed along his planned route of flight. The plt took off & headed into the deteriorating wx. While cruising beneath clouds the acft collided with rapidly rising terrain. The plt…Oct 11, 1986 · N34213 · DestroyedNTSB ATL87FA003Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Gahanna, OHThe helicopter had been conducting a series of demo flts during the day & was on the last scheduled flt of the day. To drop off the local plt who had requested the demo flts, when the loss of power occurred. They had made a take off over the taxiway & turned…Oct 9, 1986 · N52705 · DestroyedNTSB MIA87LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Lakeland, FLThe plt stated the acft lost power and he was unable to make it to the arpt. The acft crashed in a field about 3/4 of a mile from the Lakeland arpt. Post crash examination of the eng revealed a complete failure of both magnetos, resulting in the loss of power…Oct 7, 1986 · N5056S · Substantial damageNTSB LAX87LA012Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dolan Springs, AZThe pilot stated that he was climbing the helicopter up a dry wash and planned to cross a 3000 foot high ridge at about 10 feet above the terrain. As he approached the ridge the helicopter yawed to the right about 70 degrees and the acft main rotor lost RPM.…Oct 7, 1986 · N2270C · Substantial damageNTSB LAX87LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Rancho, CAA Piper PA-32R-301T collided with the ground after a forced landing. A renter pilot reported the aircraft was stolen. Examination of the aircraft revealed that there was no fuel present in the aircraft fuel tanks. It was also reported that the aircraft was…Oct 7, 1986 · N8159C · Substantial damageNTSB MKC87LA005Accident · No injuriesLimited investigationFinal reportStahl-Ameter Monnett Sonerai II · Arab, MOThe pilot stated that the aircraft had capacity for ten gallons of usable fuel, and that he flew for less that an hour before landing at columbia, Illinois. According to the pilot, the sight gauges were not accurate on the ground and he did not visually check…Oct 6, 1986 · N44KC · DestroyedNTSB MKC87LA001Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tribune, KSThe PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…Oct 6, 1986 · N84911 · Substantial damageNTSB FTW87DRD01Accident · No injuriesFinal reportCessna A188B · Gilbert, LAThe acft was conducting aerial application operations when a decrease in fuel pressure and engine surging occurred. Examination failed to reveal a reason for the loss of fuel pressure and the subsequent surging of the engine. The emergency landing had to be…Oct 6, 1986 · N53137 · Substantial damageNTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.Oct 5, 1986 · N12ZC · Substantial damageNTSB NYC87DHJ01Accident · Serious injuriesFinal reportCessna 150M · Farmingdale, NYThe plt was returning home after flying for aprx 2 1/2 hours. The plt reported that he had started the flt with full fuel tanks. The acft experienced a loss of power and the plt attempted a forced landing at an arpt. He was unable to reach the rwy and the…Oct 5, 1986 · N66256 · DestroyedNTSB MIA87FA003Accident · 1 fatalField investigationFinal reportGriffin STAR-LITE · Raymond, MSThe plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…Oct 5, 1986 · N124PK · DestroyedNTSB FTW87LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Minden, LAThe non-instrument rated plt entered IMC conditions while in cruise flt on a dark night at an altitude of 500 ft. he then entered a descent to reach VMC. During the descent, the helicopter collided with a tree at aprx 75 to 100 feet AGL,then crashed to the…Oct 5, 1986 · N90455 · Substantial damageNTSB SEA87IA004Incident · No injuriesIncident investigationFinal reportCessna 402C · Everett, WAWhile enroute from seattle to bellingham on a regularly scheduled passenger commuter flight the left engine number 3 exhaust riser burned through. The pilot visually detected a discoloration on the left engine nacelle inflight but was unable to execute a…Oct 4, 1986 · N2651Y · Minor damageNTSB LAX87LA004Accident · No injuriesLimited investigationFinal reportGillon Quickie Q2 · Goleta, CAPrior to the accident flight of the experimental homebuilt, the spark plug inserts in the engine cylinders were changed to steel ones. The pilot said that during the flight he heard a loud noise emanate from the engine followed by a partial loss of power. The…Oct 4, 1986 · N22SD · Substantial damageNTSB LAX87DVG01Accident · No injuriesFinal reportSmith & R. Mathews RV-4 · Lincoln, CADuring a local test flight of an experimental home built acft, the engine experienced a total loss of power at aprx 3000 ft AGL. Unable to return to the airport, the plt landed in an open field. Aprx one ft above the two foot high grass, the plt raised the…Oct 4, 1986 · N63SM · Substantial damageNTSB DEN87DTE01Accident · No injuriesFinal reportCassutt Sport Racer · Brighton, COThe plt rprtd that he did not properly lock the canopy & it came open drg flt at 7000 ft MSL. He reduced the speed & attempted to close the canopy, but was not successful. He diverted & attempted to land at the van aire arpt while holding the canopy with his…Oct 4, 1986 · N913M · Substantial damageNTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…Oct 3, 1986 · N38688 · DestroyedNTSB NYC87LA004Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Derry, PAThe flight suffered an engine power loss while in cruise flight due to fuel starvation. The pilot stated that a pretakeoff check of fuel gauges was made and they all indicated fuel on board.Oct 2, 1986 · N258W · Substantial damageNTSB MIA87LA001Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Titusville, FLThe plt stated that while at 9,000 ft, aprx 8 miles north of tico arpt, he lost fuel pressure in his left eng and while attempting to restart the eng and find the arpt he was unable to make it to the runway. The acft landed about 150 ft short and collided…Oct 1, 1986 · N29HH · Substantial damageNTSB NYC86LA244Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Beaver Falls, PAThe plt stated that the acft experienced engine problems during cruise flt and crashed about one mile northeast of Beaver Falls, PA. Post accident testing revealed that the engine was capable of developing power in accordance with the manufacturer's…Sep 29, 1986 · N5244K · DestroyedNTSB CHI86LA234Accident · No injuriesLimited investigationFinal reportBeech BE-95-55 · Shelbyville, INWhile at cruise after sunset, the pilots discovered that the left panel lights and the overhead light were not operating. A white beam flashlight was used to observe the airspeed indicator, however, continued use of the flashlight blinded the pilots' vision…Sep 29, 1986 · N562T · Substantial damageNTSB CHI86FA233Accident · 1 fatalField investigationFinal reportBeech E18S · Chicago, ILThe acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…Sep 29, 1986 · N101VE · DestroyedNTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…Sep 28, 1986 · N3578L · Substantial damageNTSB DEN86LA263Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Durango, COWhile flying low level inside a river gorge at 200-300 feet above the water, the balloon impacted a power line and fell into the river.Sep 28, 1986 · N2346H · DestroyedNTSB MIA86FLT02Accident · Serious injuriesFinal reportMccoy Robert-Michael Breezy · Meridian, MSDuring flt testing of the newly purchased acft which was conducted prior to the x-country flt home, oil consumption/leakage was determined to be about 3 qts per hr. The plt stated that he planned the flt home in short hops so as to minimize oil usage & had…Sep 27, 1986 · N3269X · DestroyedNTSB LAX86FUG05Accident · Serious injuriesFinal reportSchweizer SGS-1-35C · Palm Springs, CADuring a pleasure flight, the acft was not getting the lift required to maintain alt. The plt decided to return to the arpt, however, enroute the plt realized that he would not make it back to the rwy. The plt decided to land in an east west direction on a…Sep 27, 1986 · N2673H · Substantial damageNTSB BFO86FHD04Accident · No injuriesFinal reportWhite Lightning WLAC-1 · Wilmington, DEDuring a vfr-on-top flt with no flt plan, the eng lost power from fuel starvation. The plt did not recognize that fuel was still remaining in a non-selected aux tank. Subsequently, the acft was damaged during a forced landing on the median of a highway.…Sep 27, 1986 · N100WL · Substantial damageNTSB MIA86LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, FLWhile established in curise flight the engine failed and all attempts to start it were to no avail. The pilot executed a forced landing to a soft field and the aircraft nosed over. Examination of the engine revealed that the #1 engine exhaust valve had failed…Sep 26, 1986 · N56522 · Substantial damageNTSB CHI86LA236Accident · No injuriesLimited investigationFinal reportHughes 269B · Baldwin, WIAfter picking up his passenger at williams pipeline, minneapolis, Minnesota, the plt flew eastward along interstate 90 enroute to a pipeline near wausau, Wisconsin. While flying at approximatelly 400 feet, the plt and passenger stated that the engine started…Sep 26, 1986 · N9427F · Substantial damageNTSB ATL86FA265Accident · 1 fatalField investigationFinal reportCessna A-37A · Yantley, ALThe plt had just purchased the acft which had an experimental airworthiness certificate. During a preflt wx briefing, he was advised of towering cumulus clouds along his route. After takeoff, he initiated a climb to FL 240 & leveled off aprx 10 min later.…Sep 25, 1986 · N3757Z · DestroyedNTSB MKC86FA195Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Harvard, NEThe plt received a wx briefing for a night, business flt. At the time of the briefing a reporting station 22 NM nw of the acdt site had a broken ceiling at 2300 ft with good vis. The acdt occurred about 2 hrs after the briefing less than 2 mi from the…Sep 24, 1986 · N7744N · DestroyedNTSB MIA86LA253Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Deltona, FLThe pilot stated that while in cruise flight the engine failed and he executed a forced landing to a lake and ditched the aircraft. The aircraft was recovered and examination of the power plant and systems failed to reveal any malfunction/failure that would…Sep 24, 1986 · N24854 · Substantial damageNTSB SEA86LYA02Accident · No injuriesFinal reportInav Moni · Riverside, ORPower plant seized in flight. Plt attempted forced landing on road, wings struck sagebrush on road shoulder. It was not determined why the engine seized in flight.Sep 23, 1986 · N39200 · Substantial damage