NTSB investigations, OR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA' 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.
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."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA82DA077Accident · No injuriesFinal reportRobinson R-22 · Hillsboro, ORThe instructor pilot was demonstrating a hovering autorotation to the student from approximately an 18 inch altitude. Shortly after touchdown, which was level and without movement in any direction, the aircraft started to roll to the left. The pilot reported…NTSB SEA82DA041Accident · No injuriesFinal reportGrumman AA-5B · Lebanon, ORThe pilot had about 3 hours of flying experience in this make and model of aircraft. This was his first landing with rear-seat passengers. The pilot reported that the wind was variable and gusting to 15 knots. During the landing flare, the pilot felt a sudden…NTSB SEA82DA039Accident · Minor injuriesFinal reportMooney M20F · Maupin, ORThe pilot reported that the engine lost power during takeoff after he raised the gear and flaps. He stated that he lowered the nose and the stall warning buzzer sounded, but he was unable to obtain the necessary airspeed. He stated that the power began to…NTSB SEA82DYM12Accident · No injuriesFinal reportPiper PA-28-181 · Albany, ORWhile proceeding from a restaurant parking area to the runway, the aircraft had to be taxied across a bridge. The bridge was 30 ft wide and 50 ft long. It had no side rails and was used to cross a drainage ditch. A slight right turn was required just before…NTSB SEA82FYM11Accident · Minor injuriesFinal reportHiller UH-12E · Mount Angle, ORThe aircraft was being used on an external load operation. On his fourth load, the pilot was to transport a 1190 lb electric pump and fan from the back of a pickup truck. While preparing to lift the load, the pilot was not satisfied with its position. He…NTSB SEA82DA033Accident · No injuriesFinal reportCessna 172RG · Plush, ORThe pilot departed lakeview, Oregon on a local flight with two passengers on board. After a stopover at a private airstrip, he began a short field takeoff from a grass/gravel/dirt runway that was 2500 ft in length. The density altitude was approximately 4600…NTSB SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…NTSB SEA82FYM10Accident · No injuriesFinal reportWeatherly 201C · Wasco, ORThe pilot reported that during takeoff, the engine did not maintain full power. While landing in a residential area, the aircraft struck a telephone wire and three trees. An examination of the engine revealed no obvious defects that would cause a loss of…NTSB SEA82FYK08Accident · Minor injuriesFinal reportKaman HH-43F · Sutherlin, ORThe helicopter was being used on a logging operation. After releasing a load from a hover out of ground effect, the pilot began to turn and accelerate. About two-thirds to three-fourths of the way through a 180 degree turn, the aircraft began a sudden, very…NTSB SEA82FYM09Accident · Serious injuriesFinal reportRockwell Comdr 112TCA · Aurora, ORDuring takeoff, the plane was observed to rotate to a steep nose high attitude, then roll into a steep bank, go into a descent, and crash. During the descent, it rolled to a wings level attitude before impacting with the nose slightly down. An examination of…NTSB SEA82DA028Accident · No injuriesFinal reportBoeing A75N1 · Medford, ORAfter landing the pilot of Taylorcraft, N9507B, was cleared to proceed to his parking area. At 1054:50, ground control advised him of stearman, N56270, approaching from the opposite direction. The Taylorcraft pilot adjusted his taxi path to the right of the…NTSB SEA82DA026Accident · No injuriesFinal reportBellanca 7KCAB · Burns, ORDuring landing in calm wind conditions, the aircraft bounced slightly. On the second touchdown, it veered left and struck a snowbank. The student pilot reported that it seemed like the left brake froze. The left brake was examined for possible dragging and…NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…NTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…NTSB SEA82FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Pleasant Hill, ORThe plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…NTSB SEA82FA013Accident · 1 fatalClosedErco 415-C · Ashland, ORNTSB SEA82FA012Accident · 2 fatalClosedPiper PA-32 · Brogan, ORNTSB SEA82FA010Accident · 1 fatalClosedPiper PA-28 · Mill City, ORNTSB SEA82FYK05Accident · No injuriesClosedPiper PA-28R · Cheshire, ORNTSB SEA82DYM06Accident · No injuriesClosedMitsubishi MU-2B · Madras, ORNTSB SEA82DYM07Accident · No injuriesClosedHiller Acft UH-12E · Nashville, ORNTSB SEA82FA006Accident · 5 fatalClosedCessna 172M · Payette, ORNTSB SEA82DYK06Accident · No injuriesClosedCessna 182 · Redmond, ORNTSB SEA82DYM05Accident · No injuriesClosedCessna 152 · Sheridan, ORNTSB SEA82DYK04Accident · No injuriesClosedCessna 185F · Burns, ORNTSB SEA82FYM04Accident · Serious injuriesClosedPiper PA-22 · Hillsboro, ORNTSB SEA82DYM01Accident · No injuriesClosedCessna 172 · Long Creek, ORNTSB SEA82FA003Accident · 1 fatalClosedMaule M-5 · North Bend, ORNTSB SEA82DYM03Accident · No injuriesClosedCessna 172 · Ukiah, ORNTSB SEA82DYK03Accident · Minor injuriesClosedBeech 76 · Sutherlin, ORNTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, ORNTSB SEA82DYM02Accident · No injuriesClosedAeronca 7AC · Corvallis, ORNTSB SEA82DYK01Accident · No injuriesClosedPiper PA-18A · Burns, ORNTSB SEA81DYM48Accident · No injuriesClosedBell 47G3B1 · Albany, ORNTSB SEA81DYM47Accident · No injuriesClosedForney 415-C · Gleneden Beach, ORNTSB SEA81FYM46Accident · 1 fatalClosedDruine D-31 · Corvallis, ORNTSB SEA81FYM44Accident · Minor injuriesClosedEvans Spcl 1 · Aurora, ORNTSB SEA81FA056Accident · 2 fatalClosedAeronca 7AC · Myrtle Creek, ORNTSB SEA81FYM43Accident · No injuriesClosedPitts S-1C · Troutdale, ORNTSB SEA81DYK18Accident · No injuriesClosedHiller Acft UH-12L · Malin, ORNTSB SEA81FYM45Accident · No injuriesClosedCessna 421B · Mulino, ORNTSB SEA81DYM38Accident · No injuriesClosedPiper PA-28 · Pacific City, ORNTSB SEA81FYM42Accident · Serious injuriesClosedPiper PA-28 · Medical Spgs, ORNTSB SEA81DYM39Accident · No injuriesClosedGeo. Mccall KR-2 · La Grande, ORNTSB SEA81FYM37Accident · No injuriesClosedCessna 310J · Hillsboro, ORNTSB SEA81DYM40Accident · No injuriesClosedCessna 182Q · Enterprise, ORNTSB SEA81FYK17Accident · Serious injuriesClosedPiper PA-12 · Bend, ORNTSB SEA81DYM35Accident · No injuriesClosedPiper PA-28 · Yachats, ORNTSB SEA81DYK15Accident · Minor injuriesClosedCessna 140 · Ashland, ORNTSB SEA81FYK16Accident · No injuriesClosedBeech 95-C55 · Roseburg, OR