OpenAirDocs.org

NTSB investigations

35,889 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 LAX82FVG29Accident · No injuriesFinal reportCessna 150 · Sacramento, CAThe purpose of the flight was to "shakedown" the aircraft and to break in a newly overhauled engine. A thorough preflight was made and some water was drained from the fuel tanks. (The aircraft had not been flown for some period of time.) While climbing after…Jul 21, 1982 · N22912 · Substantial damageNTSB CHI82DA265Accident · No injuriesFinal reportEagle DW-1 · Murdock, MNThe pilot was en route to a bean field when the ground adjustable propeller came out of adjustment. The pilot dumped the load and made a forced landing in a beanfield. During the landing, the aircraft nosed over and was substantially damaged. An investigation…Jul 21, 1982 · N8801Y · Substantial damageNTSB NYC82FNC11Accident · Serious injuriesFinal reportFirefly 7 · Winslow, MEWhile descending to land in an open field, the balloon began drifting towards high powerlines. In an attempt to avoid a collision, the pilot fired the burner approximately nine times, using short blasts of the burner. The balloon failed to gain altitude and…Jul 20, 1982 · N4041P · Substantial damageNTSB FTW82DA285Accident · No injuriesFinal reportAerospatiale AS-350D · Gulf Of MexicoDuring an over water flight, the engine chip detector light illuminated and shortly thereafter, the engine failed. The pilot made an autorotative landing in the Gulf Of Mexico with no further damage. All three rotor blades were full of holes and tears and one…Jul 19, 1982 · N5771L · Substantial damageNTSB LAX82DA265Accident · No injuriesFinal reportAir Tractor AT-301 · San Joaquin, CAThe aircraft engine started running rough on a ferry flight and the pilot decided to make a precautionary landing in a cotton field. During the landing the aircraft nosed over.Jul 18, 1982 · N4326S · Substantial damageNTSB ATL82FID11Accident · No injuriesFinal reportVolmer VJ-22 · Lewiston, VAPilot ferrying aircraft to new owner and lost power. A hard forced landing was made in a pasture. Aircraft contacted ground at a 30 degree angle which failed landing gear. Pilot had zero time in the aircraft prior to this flight. Owner of aircraft had power…Jul 18, 1982 · N2297Z · DestroyedNTSB SEA82FYP09Accident · 3 fatalFinal reportCessna 172M · Wenatchee, WAReportedly, the pilot, a geologist, was on a flight to check rock formations. Prior to the accident, the plane was observed flying up a canyon at low altitude and airspeed. About 3/4 mile from the accident site, two witnesses on a rocky cliff at about 3500 ft…Jul 17, 1982 · N72655 · DestroyedNTSB LAX82FA260Accident · 5 fatalField investigationFinal reportCessna TR182 · Happy Camp, CAThe aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined.Jul 17, 1982 · N736EY · DestroyedNTSB ANC82DA060Accident · No injuriesFinal reportPiper PA-22 · 65 Mi.Ene Of Mc, AKDuring flight, the pilot noticed a progressive loss of power. He elected to make an emergency landing on a gravel bar. During the landing, the aircraft rolled through a shallow slough where the left main gear hit a log. The nose gear then hit a bank at the…Jul 17, 1982 · N891A · Substantial damageNTSB NYC82DA156Accident · Minor injuriesFinal reportDowner Aircraft Industries Republic RC-3 · Southwick, MADuring flight, the engine began to run rough. The pilot attempted to correct the situation but the engine continued to operate at reduced power. He elected to land the amphibious plane in a field and extended the gear. However the pilot saw that the aircraft…Jul 16, 1982 · N6426K · Substantial damageNTSB LAX82FA262Accident · 1 fatalField investigationFinal reportCessna T-210L · Reno, NVThe pilot was descending in a mountainous area and did not clear the high terrain before collision with the ground occurred. The pilot was in radio communication with Reno tower and was given landing instructions. There was no verbal indication of trouble on…Jul 16, 1982 · N66GH · DestroyedNTSB LAX82FA258Accident · Minor injuriesField investigationFinal reportCessna 210L · Santa Ana, CAAbout 3 mi se of the arpt, with gear down & full flaps, the eng fuel pressure went to zero & the eng lost power. The pltdid not declare an emergency, but advised tower that the acft lost the fuel pressure. The plt was then cleared for a landing on rwy 19R. As…Jul 16, 1982 · N59242 · Substantial damageNTSB LAX82AA259Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · Morton, WYWhile flying in good wx over central Wyoming, the captain noted a gentle wave motion that caused the autothrottles to react. Therefore, he disengaged the autothrottles and autopilot. The acft had lost 250 ft drg the wave motion, so the captain turned on the…Jul 16, 1982 · N1815U · Minor damageNTSB SEA82DA112Accident · Serious injuriesFinal reportBell 47G-2 · Harrah, WAThe pilot reported that before taking off, the fuel quantity guages indicated there was sufficient fuel to complete one more load and still have an adequate reserve. After dispensing the load, the engine lost power while he was returning to the nurse truck.…Jul 15, 1982 · N6145C · Substantial damageNTSB NYC82FA155Accident · 4 fatalField investigationFinal reportCessna 177RG · Cross Fork, PAAt 2132 the plt contacted fss reporting his position, lightning to his east & requested wx around his position. He was advised of thunderstorm activity, deteriorating conditions & that VFR flt was not recommended. He was also advised to reverse course. At…Jul 15, 1982 · N7584V · DestroyedNTSB ATL82IA198Incident · No injuriesIncident investigationFinal reportCessna 177RG · Near Sparta, GAThe aircraft experienced power failure while in cruise flight en route from wilmington, NC to atlanta ga. Following the power loss, the pilot landed gear up in an open field Near Sparta, GA. Investigation revealed that the aircraft had last been refueled on…Jul 15, 1982 · N33226 · Minor damageNTSB ATL82FA196Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Roswell, GAAbout 12 minutes after takeoff the plt reported "...alternator or generator trouble" & requested to return to the arpt. He later reported that he was having radio problems. The plt was vectored to intercept the ILS rwy 20L apch course. The accident occurred…Jul 15, 1982 · N6868P · DestroyedNTSB MIA82DA154Accident · No injuriesFinal reportBellanca 17-31 · Lake Wales, FLThe aircraft was on a maintenance flight to check a recently installed engine oil temperature gauge. After determining that the gauge was operating satisfactorily, the pilot began a descent toward the airport. While descending through 3000 ft, the pilot…Jul 14, 1982 · N7373V · DestroyedNTSB FTW82DA281Accident · No injuriesFinal reportBell 206B · Sabine, TXDuring flight at about 500 ft AGL, the engine lost power. The pilot began an autorotative landing and made a mayday call. He autorotated to a marshy area which had 4 to 5 ft grass. The helicopter touched down hard and the main rotor blades flexed down and…Jul 14, 1982 · N116AL · Substantial damageNTSB MIA82DA153Accident · Minor injuriesFinal reportPiper PA-18 · Kenneth City, FLWhile cruising the aircraft oil pressure dropped and smoke entered the cockpit, so made a forced landing in a small field. The aircraft hit a stump and nosed over. An investigation revealed a broken oil line to a pressure gauge and oil leaked on a hot exhaust…Jul 13, 1982 · N225NY · Substantial damageNTSB FTW82DA280Accident · No injuriesFinal reportPiper PA-38-112 · New Braunfels, TXThe pilot reported that as he attempted to apply power at the end of a descent, the engine failed to respond. Approach control provided vectors to an airport, but the aircraft was too low to reach it. The pilot selected a road for a landing, but noticed power…Jul 13, 1982 · N25187 · Substantial damageNTSB ATL82DA214Accident · No injuriesFinal reportHiller UH-12E · Centre, ALWhile returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing.Jul 13, 1982 · N28872 · Substantial damageNTSB FTW82DA279Accident · No injuriesFinal reportGrumman G-164B · Beedeville, ARThe pilot proceeded to the job site with a load of urea. He circled for about 15 minutes waiting for the flagmen to arrive, then elected to return to the airport. As he leveled the plane, he experienced a gradual loss of power and was unable to maintain…Jul 12, 1982 · N6678K · DestroyedNTSB CHI82DA246Accident · No injuriesFinal reportRepublic RC-3 · Saginaw, MIThe pilot stated that he took off with 35 gal of fuel aboard. After about 128 nautical miles, the engine lost power. While landing in a muddy corn field with the gear retracted, the aircraft slid a short distance then nosed over. One of the first persons to…Jul 12, 1982 · N6444K · Substantial damageNTSB ANC82DAG35Accident · Minor injuriesFinal reportPiper PA-28-140 · Wasilla, AKPilot had opportunity to refuel and did not. On one flight before accident he successfully made a forced landing due to fuel starvation. He figured he had enough fuel for one more flight. During this flight engine quit and the pilot landed in a ditch…Jul 12, 1982 · N9891W · Substantial damageNTSB SEA82FYP08Accident · Serious injuriesFinal reportLark IS28B2 · Springdale, WAThe pilot received an aerial tow to 5000 feet and was able to find lifting currents for approximately 1.5 hours. Unable to obtain adequate lift the pilot decided to attempt an off airport landing on a dirt road crossing a wheat field. At an altitude of…Jul 11, 1982 · N9255Z · DestroyedNTSB NYC82FA148Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Newburg, PAThe pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…Jul 11, 1982 · N28970 · DestroyedNTSB ANC82FA056Accident · Minor injuriesField investigationFinal reportBell 212 · 38 Se Barrow, AKWhile executing a precautionary landing after hearing a screeching sound the plt lost directional control & the helicopter landed while spinning. Examination revealed that the primary tail rotor driveshaft quill coupling had failed. The 204-040-604-5 female…Jul 11, 1982 · N59572 · Substantial damageNTSB NYC82DA152Accident · No injuriesFinal reportEnstrom F28A · Hammonton, NJThe pilot performed an autorotation when the aircraft's engine lost power. Examination revealed no preimpact malfunction or failure.Jul 10, 1982 · N22BF · Substantial damageNTSB NYC82FNA19Accident · No injuriesFinal reportBreezy RL4-1 · Andover, MADuring flt the plt felt something snap or break on the acft. The control wheel movement for the aileron became exceedingly harder to move & the acft started to flutter in an up & down motion. He reduced power to slow the flutteringaction, but was not able to…Jul 9, 1982 · N2343 · Substantial damageNTSB NYC82DA147Accident · No injuriesFinal reportPiper PA-18-150 · Cape May, NJAfter departing on a banner towing mission, the pilot experienced a sudden power loss. He had insufficient power and altitude to return to the field and elected to ditch in a creek. An examination of the engine revealed that the no.2 exhaust valve, pn 75068,…Jul 9, 1982 · N6897B · Substantial damageNTSB FTW82DA274Accident · Minor injuriesFinal reportCessna 152 · Bryan, TXWhile on a solo cross-country flight, the student pilot landed twice for fuel, but his credit cards were not accepted to obtain services. He was told that the cards would be acceptable at coulter field which was 7 mi away. He visually checked the fuel and…Jul 9, 1982 · N24890 · Substantial damageNTSB CHI82DA242Accident · No injuriesFinal reportGrumman American AA-1B · Near Zanesville, OHDuring flight in his newly purchased aircraft, the pilot let his right tank run dry. He then switched to his left tank which he believed was more than 1/2 full. After flying about 15 miles further, the engine began running rough and then quit. While landing…Jul 9, 1982 · N32NA · Substantial damageNTSB ATL82DA192Accident · No injuriesFinal reportPiper PA-28-180R · Carrollton, GADuring cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation…Jul 9, 1982 · N7550J · Substantial damageNTSB FTW82DA271Accident · No injuriesFinal reportCessna 182J · Munester, TXDuring flight, the engine began losing power and both occupants detected a strong odor of gasoline. The pilot made a successful forced landing in a field. He stated that the engine lost all power on final approach. After coming to a stop, the pilot and…Jul 7, 1982 · N2405Q · DestroyedNTSB ATL82DA191Accident · No injuriesFinal reportBeech V35 · Huntington, WVBefore departing st louis, MO, attempts to restart the engine were unsuccessful until an auxiliary power unit was used. The aircraft took off at 1746, and about one hour later, the pilot noticed that the ammeter indicated a discharge. The flight was…Jul 6, 1982 · N7969M · Substantial damageNTSB NYC82IA137Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Flushing, NYDuring initial climb, the amber leading edge flat light remained lit after flap retraction from 5 degrees to 2 degrees. Moderate aileron and rudder inputs were required to maintain wings level flight. After cycling the flaps from 5 back to 2 degrees, the same…Jul 5, 1982 · CGAAA · Minor damageNTSB NYC82FGM12Accident · No injuriesFinal reportAerospatiale SA 316B · Crafton, PAShortly after takeoff the pilot heard a loud grinding noise and felt a vibration emanating from the rear of the aircraft. Immediately, the nose yawed to the left and the engine failed. The pilot entered autoration and made a hard landing. Examination of the…Jul 5, 1982 · N8259 · Substantial damageNTSB NYC82DA142Accident · Minor injuriesFinal reportBeech B23 · North Castle, NYAircraft was ditched and sank in a reservoir in 20 feet of water after the engine failed in flight. The crankshaft was found to be fractured when aircraft was raised. Oil had sprayed on the windshield. Avco-lycoming part number that failed was 74968 serial…Jul 5, 1982 · N9133T · Substantial damageNTSB MIA82DA157Accident · 4 fatalFinal reportPiper PA-28R-201T · West Of Cross C, FLAt about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.…Jul 5, 1982 · N505HPNTSB CHI82DA235Accident · Minor injuriesFinal reportGrumman American AA-1C · Danville, ILThe student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the…Jul 5, 1982 · N9830U · DestroyedNTSB LAX82FA242Accident · No injuriesField investigationFinal reportBell 206B · Grand Canyon, AZPilot lost power during sight-seeing flight and decided to make a precautionary landing. He aborted one landing due to wind and was at 50 AGL for 2nd attempt when power decreased. Due to wind and lack of power the aircraft made contact with a tree and the…Jul 4, 1982 · N4778R · Substantial damageNTSB LAX82DA243Accident · No injuriesFinal reportCessna 182J · Deer Valley, AZWhile climbing through about 6500 ft, a loud bang was heard and the pilot saw the engine cowling buckle. About 10 seconds later, the engine ceased to operate. The pilot declared an emergency and landed on an uncontrolled airport. After landing, an examination…Jul 4, 1982 · N3317F · Substantial damageNTSB FTW82DA267Accident · No injuriesFinal reportCessna 182G · Abbeyville, LAThe pilot reported that he had taken off on a local flight and was at about 1000 ft AGL when the engine lost power. He attempted to restart the engine, but was unable. The aircraft was landed firmly on a roadway. The pilot smelled gas fumes and exited from…Jul 4, 1982 · N2408R · DestroyedNTSB FTW82DA266Accident · No injuriesFinal reportGreat Lakes 2T-1A-2 · Mexia, TXThe aircraft nosed over during a landing on the taxiway. The pilot said he landed on the taxiway because his engine quit.Jul 4, 1982 · N5762N · Substantial damageNTSB FTW82DA265Accident · No injuriesFinal reportAero Commander 100 · Dekalb, TXThe pilot lost power during a local flight and attempted a landing on a highway. Control was lost and aircraft collided with a fence. The aircraft was landed downwind. Post accident check showed 125 mag drop on both mags and a maximum static of 2350.Jul 4, 1982 · N3780X · Substantial damageNTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…Jul 4, 1982 · N39714 · Substantial damageNTSB ATL82DA194Accident · Minor injuriesFinal reportCessna 182 · Madison, INThe pilot reported that he experienced a gradual loss of power on a dark night. The terrain was hilly and covered with trees, and reportedly, the pilot elected to land upwind on the Ohio river. After ditching, the occupants egressed and swam to shore, but the…Jul 4, 1982 · N5584B · DestroyedNTSB FTW82FRA24Accident · Serious injuriesFinal reportBlanik L-13 · Katy, TXThe pilot rented the glider after a flight check-out was completed and was given an aerial tow to an altitude of approximately 2000 feet. According to the passenger, the pilot became disoriented and lost sight of the airport. Unable to find any lifting…Jul 3, 1982 · N273AS · Substantial damageNTSB CHI82DA233Accident · No injuriesFinal reportCessna 150M · Santisgo, MNDuring aerial photo mission engine began to run rough. Pilot headed home but was forced to land enroute. Aircraft swerved and nosed over. Exam of engine showed exhaust valve stuck open.Jul 3, 1982 · N63183 · Substantial damage