FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 20070110000429ACessna 172S · Lancaster, CA(-23) The pilot had made a full stop landing just short of the fixed distance markers on runway 24. He then began a takeoff from that point. Just past the end of the fixed distance markers, at about 40 to 50 knots, the left wing "lifted" and the airplane…Incident 20070110000409IBeech S35 · Wahoo, NE(-23) The pilot and his one passenger were enroute from davenport, Iowa to Wahoo, Nebraska. The pilot stated he had a new garmin 430 installed and was observing it while he was on approach. The winds were 12 @ 210 as the pilot slowed to land on runway 20 at…Accident 20070110000379ACessna 310 · Clinton, MS(-23) After departing hawkins field (hks)(1750Z), pilot requested to return to hks. Pilot stated he had a small problem he wanted to check on the ground. The aircraft crashed under unknown circumstances (1810Z) 2 miles west of runway 16 hks. The pilot was…Incident 20070110000179ICessna 320D · Boise, ID(-23) The aircraft departed the caldwell, ID airport (eul) and during landing gear retraction the pilot heard a loud "bang." He lowered the landing gear and did not get a "gear down" safe indication (3 green lights). He returned to eul for a low approach to…Incident 20070109831079IBeech 200BEECH · Bloomington/No, IL(-23) [privacy data omitted] aircraft was enroute from pratt, Kansas (ptt) to buffalo, NY (buf) in cruise at flight level when the pilot's windshield shattered, but remained intact. The aircraft diverted to Bloomington, IL (bmi), declared an emergency and…Incident 20070109003269IDoug MD11F · New York, NY(-23) Crew reported that during landing roll runway 31R jfk flight AZ9170, 01/09/07 at 0645 hrs with thrust reverser open, a right yaw movement was manually corrected. After thrust reverser closure the "reverser #1 fault alert on." Rohr thrust reverser…Accident 20070109002309AAmtr THORPT18 · Edinburg, OH(-23) At approximately 0806 N54DT departed from moore county airport (SOP) southern pines, north carolina for portage county airport (29G) ravenna, Ohio. On approach to 29G the engine lost power due to fuel exhaustion. The pilot attempted to land the aircraft…Accident 20070109001339ACessna 207A · Kenai, AK(-23) The pilot departed the Kenai airport in a Cessna 207, N9941M, on a cargo flight to kokhanok, Alaska, approximately 75 minutes west. Approximately 15 minutes after departure the pilot reported having engine trouble and was going down about mid-channel.…Incident 20070109001029IPiper PA28161 · Vero Beach, FL(-23) During solo training flight by the student pilot, on approach to landing in high winds, he overcompensated the rudder usage. Due to the overcompensation of rudder, the aircraft turned to the right causing the main landing gear to go off the runway. The…Incident 20070108001019IPiper PA32R300 · Salina, KS(-23) The aircraft departed sln enroute to mkc. Approximately 5 minutes after takeoff, the pilot could not control the propeller. Engine oil began to cover the windshield, causing zero visibility. The pilot declared an emergency and returned to sln, where the…Accident 20070108000529APiper PA60601P · Jamestown, NY(-23) On January 8, 2007 at 1445 gmt a Piper aero star, PA-60-601P, N720Z crashed immediately after takeoff from runway 25 at the kjhw airport with an IFR flight plan to kbuf. The current conditions were IMC with snow and rain. The aircraft came to rest…Incident 20070108000029IBeech B300 · Denver, CO(-23) On January 8, 2007 at 0945 MST a Raytheon B-300, N945SH registered to shelter enterprises, collided with a snow bank during landing at Centennial Airport Denver, CO. Report by both pilots indicated a normal approach and touch down on the centerline of…Accident 20070107000399ACessna 207A · Akiak, AK(-23) The pilot stated that he flew a high, steep final approach path to a night landing at kipnuk, AK airport. He intended to land on a slight rise at the south end of the runway but actually touched down firmly just beyond that point. The first part of the…Accident 20070107000239ABell 206B · Boise, ID(-23) After lift off from a non-movement area, the aircraft had a dynamic rollover probably caused by contact with sage brush.Incident 20070107000039IMooney M20J · Sheridan, WY(-23) While on a cross country flight from bozeman, mt to spearfish, ND pilot stated that he became sick and suffered extreme nausea. He decided to land at Sheridan, WY. Pilot landed on runway 32 and forgot to extend the landing gear.Accident 20070106008759AScwzer SGS233 · Immokalee, FL(-23) During the automotive tow of the glider, the "weak-link" broke at the automotive end of the tow rope. The glider landed hard on the grass runway.Incident 20070106001179IPiper PA28R180 · Millington, TN(-23) On January 6, 2007, at approximately 1530 hrs. CDT, the pilot [privacy data omitted] was doing touch and gos at Charles Baker airport (2M8). The pilot [privacy data omitted] states that he had completed four (4) touch and gos on runway 36. During his…Incident 20070106001159IMooney M20F · Madera, CA(-23) During after landing rollout, the pilot remembers reaching up to retract the flaps. While his eyes were still inside the cockpit he felt the airplane settle and heard/felt the propeller striking the runway. Post incident examination found the right main…Accident 20070106000919ARyan ST3KR · Lake Butler, FL(-23) The pilot [privacy data omitted] stated the aircraft lost power and made an emergency landing in a small field near Lake Butler, Florida. The aircraft hit the very top of a tree and descended at an angle of approximately 50 degrees to the surface.…Incident 20070106000649ICessna 172M · Denver, CO(-23) On January 8, 2007, the pilot [privacy data omitted] was performing touch-and-goes with a student in Cessna 172M serial #17263355, N5138R. After landing on runway 29R, the student was taxiing the aircraft back to the ramp area when a gust of wing pushed…Accident 20070106000509ACessna 182G · Lamar, CO(-23) On January 6, 2007, the pilot [privacy data omitted] was on an IFR flight plan from Colorado springs, Colorado (cos) to Lamar, Colorado (laa) in a Cessna 182G, serial #18255385, registration N2185R. Upon arriving at laa, visual contact was established…Incident 20070106000299IPiper PA44180 · Bakersfield, CA(-23) Aircraft departed lgb on IFR flight plan to lvk. Upon approaching ventura, pilot noticed #1 VOR failing, followed by the DME. Pilot was unable to transmit on radios, squawked 7700. Darkness was approaching and cockpit lighting was getting dimmer, he…Incident 20070106000199IBell 430 · Emmett, ID(-23) On January 06, 2007, in bound to boise the pilot noticed the transmission quill chip light illuminated. The pilot notified boi approach and landed by highway 16 close to Emmett, ID.Accident 20070105013319ABoeing 7377H4 · Santa Clarita, CA(-23) On January 5, 2007, [privacy data omitted] was a passenger on southwest airlines flight 2128 from bur to oak. During the climb the crew reported moderate turbulence to socal. The flight arrived at oak at 1815 PST. At 2114 PST [privacy data omitted]…Accident 20070105002649ACessna 150M · Bristol, WI(-23) On January 5th, 2007, the pilot [privacy data omitted] ^ stated that he created a runway on a plowed farm field. The furrows were removed and the ground compacted by his john deere 550 dozer. The pilot [privacy data omitted] ^ then stated he returned in…Incident 20070105000579IAmtr Searey · Geneva, FL(-23) The amphibious Searey experimental amateur-built kit airplane flipped while landing on lake harney. The airplane sustained minor damage to the landing gear, windshield and fiberglass hull nose section, and the private pilot received minor injuries. The…Accident 20070105000459APiper PA34200T · Manzanola, CO(-23) The pilot [privacy data omitted] departed pueblo memorial airport (kpub) for tyler, Texas in a senaca (PA-34-200T - N8231D) at approximately 0639 MST on January 05, 2007 with the tower reporting 2000 overcast, visibility 10 miles and calm winds. Pub…Accident 20070105000439AEnstrm F28A · Bruceville, TX(-23) The flight instructor was demonstrating a hovering autorotation to a student. When the helicopter contacted the ground it pitched forward until the rotor blades and nose contacted the ground. When the helicopter returned to an upright position the main…Accident 20070104000829ABbavia 8GCBC · Buckley, WA(-23) Pilot departed thun field (1S0) for a job site in Buckley WA. Pilot was attempting to land at an off airport (turf) site. Pilot applied brake pressure, the wheels locked the left main impacted a rock and the aircraft nosed over. The left wing appears to…Incident 20070104000799ICessna S550 · Louisville, KY(-23) During flight the right engine thrust reverser (tr) unlock annunciator light illuminated. The flight crew selected emer stow and completed that leg of the flight to naples FL without incident. Maintenance personnel disabled the tr in accordance with…Accident 20070104000389ACessna 182P · Columbia, SC(-23) Pilot was attempting a ILS to runway 11 @ the Columbia, SC metro airport (cae). Aircraft descended below published minimum altitude and collided with trees and ground.Incident 20070104000349ICessna 150K · Harrisonville, PA(-23) Aircraft N6447G was enroute to johnstown, Pennsylvania at 11:00 am. The aircraft was at cruise, with engine RPM at 2350, when the engine made a loud noise and began to run rough. Shortly after, the engine stopped. The pilot located the nearest field,…Accident 20070104000159ACessna R182 · Hacketts Town, NJ(-23) Aircraft was departing hackettstown airport (N05), hackettstown new jersey on January 4, 2007, runway 05. Pilot applied power for takeoff with all engine readings normal. Pilot realized during take off roll that aircraft was not developing full power…Accident 20070104000149AHughes 369D · Lyman, WA(-23) On 01/04/07, at approximately 1255 PST, a Hughes 369D helicopter, N1088G, owned and operated by the pilot [privacy data omitted] of hi line helicopters, experienced a loss of power as it was coming to a hover while performing external load work…Accident 20070104000139ACessna 182R · Batesville, AR(-23) 01/04/2007, Approx. 12:35 CDT, N2658 a Cessna CE-182R operated by barr air patrol, 1442 airport blvd. Mesquite TX crashed on approach to Batesville municipal airport (bvx), Batesville, AR. Aircraft had departed valparaiso, in for the purpose of pipeline…Accident 20070103000819AAmtr EXEC162F · Baldwin City, KS(-23) On January 3, 2007 at approx 1445 hrs local time, aircraft N113JD, rotorway/exec 162F departed paola, Kansas (miami county airport K81), with one passenger on board. Approximately 15 minutes in flight (at 1600 ft MSL), they heard a pop noise from behind…Incident 20070103000709IPiper PA24250 · Danielson, CT(-23) After landing at Danielson, CT (5B3) runway 31, the left main gear collapsed allowing the left wing tip to contact the runway surface. Wingtip drag induced adverse yaw to the left and the aircraft departed the runway after approx 2000 ft. a/c came to…Incident 20070103000639IPiper PA28R200 · Danbury, CT(-23) The pilot experienced an uncommanded gear extension during flight. Two main gear indicated down and green with the nose gear indicating intransit (unsafe). Pilot returned to dxr and landed runway 08. Upon touchdown, nose gear collapsed. There were no…Incident 20070103000539IBeech E55 · Atlanta, GA(-23) Aircraft made a gear up landing on rwy 020L at pdk. Aircraft slid on belly down the rwy for approx 700' before coming to a full stop. A transponder and a nav antenna belonging to the aircraft were found in the path between touch down and full stop.…Incident 20070103000309IPiper PA28181 · Pell City, AL(-23) The pilot stated on a night approach to runway 2 at Pell City airport (plr) he crossed the threshold in a good centerline configuration. He stated that he misjudged the ground effect and landed very hard. The aircraft bounced as he attempted to recover…Accident 20070103000249ACessna 172S · Alton/St Louis, IL(-23) After a hard landing, the student pilot attempted to arrest the bounce by adding power. The aircraft continued to bounce while veering towards the left side of the runway. The student then attempted a go-around using partial power, but struck a runway…Incident 20070103000019IBag JETSTM3201 · Atlantic City, NJ(-23) Corporate flight management inc., flight 104, a bae jetstream 3201, serial no. 906, N487UE, enroute from kdca to kacy and landed on runway 22 kacy with smoke trailing from the left engine tail pipe. ARFF responded, the occupants were evacuated on the…Accident 20070102002659ABeech 58 · Washington, IN(-23) January 2, 2007 at approximately 13:00 local time, a Beech baron, BE-58, N678DC departed runway 36 at the Daviess County Airport on a part 91 flight to Ohio county airport in hartford, Kentucky. Purpose of the flight was to relocate the aircraft for…Incident 20070102000319IBeech 95A55 · Tucson, AZ(-23) Aircraft was being operated under FAR part 91 on a dual instruction flight. Flight departed Ryan field Tucson, Arizona (kryn) at approximately 1305 MST. One landing to a go-around was accomplished. On the second touch and go the student raised the gear…Accident 20070102000259ACessna 172H · Armstrong, TX(-23) N3940R VFR T65 (weslaco TX) to jso (jacksonville TX) at 3500 ft. at approximately 0232Z a request to ATC was made to descend to 2500 ft for cloud avoidance, the aircraft continued descent to 1700, the pilot stated to ATC that he was "in trouble." Radar…Accident 20070102000219AFrchld SW3 · Tulsa, OK(-23) [privacy data omitted] on January 02, 2007, at 1140 central time, a twin engine fairchild SW-3 airplane, venezuelan registration YV-2045 was substantially damaged following loss of control while landing at Richard l. Jones jr airport. The pilot reported…Incident 20070102000049ILear 35A · Houston, TX(-23) While departing from duncan, ok (kduc) N135FA, a Learjet 35A, lost both left hand main tires during take-off. Pilot stated that during the take-off, aircraft had a slight pull to the left during rotation. Kduc UNICOM contacted the aircraft and advised…Incident 20070101831479IN22222Accident 20070101002639ABbavia 7EC · Jeffersonville, IN(-23) On January 1, 2007, at approximately 12:30 pm local time, a 1967 Aeronca champ, serial number 713, N607EC, landed on runway 18 at the Clark County Airport (kjvy). As the aircraft was slowing to a taxi speed, a gust of wind out of the southwest caused…Accident 20070101002419AOklahoma City, OK