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 20070521009249AAmtr VANSRV7A · Marysville, OH(-23) On may 21, 2007, at 0834 eastern daylight time, an experimental, amateur-built, wood evan, vans RV-7A, N7259N, sustained substantial damage after impact with a runway sign, folllowed by terrain during an attempted landing and go around from runway 27 at…Accident 20070521007829AAmtr ROTORWAY162F · Argyle, NY(-23) The aircraft N636PB, a RW162F helicopter was being operated on an instructional flight. At approximately 0.6 hours into the flight the aircraft lost power due to failure of an exhaust valve rocker arm and attendent retainer spring. The aircraft was at…Incident 20070521007609IAmtr Challengerii · Bishop, CA(-23) N116MG, challenger ii, lost engine power and stalled 10 feet above the ground while making a forced landing on a road 1 mile southeast of Bishop, CA, airport at 1155PDT. Minor aircraft damage reported.Incident 20070521006739ICessna 525 · Beverly, MA(-23) Monday, may 21, 2007 citationshares d/b/a jetcard/vector (Z5FA), N151CS, CE-525-525 enroute to Beverly, MA diverted to bedford, MA due to a generator problem caused by a bird(s) strike at 20:39 EDT, 05/21/07. The aircraft landed at 20:55 EDT without…Accident 20070520019319ANardi FN333 · Gardnerville, NV(-23) At 1431 hours local, the pilot [privacy data omitted] reported 10 miles south east of the minden, NV airport, at an altitude of 8000 feet, inbound for runway 30. Approximately 2 minutes later he again broadcast that he was having fuel problems and that…Incident 20070520016069IPiper PA28161 · Danbury, CT(-23) During touch and gos on runway 26 at Danbury airport the left main landing gear cylinder tabs (2) that the upper link assembly torque attaches to broke. Consequently during the climb the left main landing gear oleo piston assembly separated from the…Incident 20070520015369IEMB EMB145LR · Richmond, VA(-23) Approximately 2339 EDT the aircraft, while enroute from phl to gso, diverted and landed on runway 2 at ric after reporting a fire warning indication in the rear baggage cargo hold. The ARFF responded, the runway was closed and the 39 passengers, 6…Incident 20070520013229IPiper PA28235 · San Luis Obisp, CA(-23) The pilot of Piper N9170W stated he departed santa barbara, CA for turlock, CA, in VMC conditions. During the flight he heard a loud bang and started to experience a loss of engine power. Soon after engine oil was observed on the aircraft windshield. He…Incident 20070520009259IStbros SC7SERIES3 · Deland, FL(-23) During sport competition, [privacy data omitted] attempted to do a left hand turn to gain speed, appeared to over rotate and was unable to correct causing him to impact the ground and receiving fatal injuries.Incident 20070519825709IBeech F35 · Greenville, MI(-23) Pilot stated that he normally retracted the flaps as soon as possible after touchdown to minimize stone chip damage to flaps. On this landing pilot was distracted and looking for traffic in the pattern and moved the gear switch up not the flap switch…Accident 20070519019569APiper PA46350P · Indianapolis, IN(-23) 05/19/2007 At Indianapolis metro airport Piper malibu N411MD was involved in an accident. On landing on runway 15, the pilot reported no irregularities. Landing was reported as normal. The pilot reported all three landing gear indicators were showing…Accident 20070519019379AAmtr ALLEYCAT1 · Fairhope, AL(-23) During aerobatics maneuvers the pilot was attempting a loop and failed to achieve the required height above the ground which resulted in a hard impact with the runway surface.Accident 20070519018599ACessna A188 · Scotland, SD(-23) During takeoff, the aircraft could not stay airborne and came to rest beyond the boundary of the airfield. The right wing separated from the aircraft and the fuselage was twisted. The pilot was not injured. The aircraft was moved before notification of…Accident 20070519009999APiper PA32300 · Kenai, AK(-23) Pilot stated that he made a normal approach and landing. Upon touchdown and during rollout the left main gear detached from the airframe. The aircraft skidded in a straight line and the left wing tip and left horizontal stabilizer received damage. There…Accident 20070519009969ACessna A188B · Fabens, TX(-23) On may 19, 2007, at approximately 0945, N3863J, a Cessna CE-188-A188A, departed fabiens airport, fabiens, Texas for the first pass of aerial application. On departure runway 26, the aircraft departed the left side of the runway due to gusty winds. The…Accident 20070519009489AScwzer SGS126A · Lake Elsinore, CA(-23) Pilot encountered loss of lift, which caused a high descent rate and loss of altitude. Pilot was unable to make runway. Pilot is a student pilot. Aircraft's annual inspection was current. The aircraft did not have any mechanical malfunctions. Pilot…Accident 20070519009149AAyres S2RHGT65 · Tyndall, SD(-23) Aircraft hit power lines and crashed. A post accident fire destroyed the cockpit area. The pilot received fatal injuries and the aircraft was destroyed. Witnesses reported heavy rain and pea sized hail during the time of the accident. The owner/operator…Incident 20070519008849IDiamon DA40 · Duchesne, UT(-23) On may 19, 2007 at 2230 MDT, a diamond DA-40A, N500NA, piloted by [privacy data omitted] attempted to perform a touch-n-go at duchesene airport, UT (U69). The aircraft drifted off of centerline and exited the runway on the right side and came to rest 20…Accident 20070519008659AAmtr BUCKER131E · Memphis, TN(-23) The pilot and a witness stated that he lined up his approach to land in the grass parallel to runway 35 at General Dewitt Spain Airport. On touchdown, the aircraft bounced one time, then touched down just short of the second VASI light assembly. The…Incident 20070519008109ITmpson Naviona · Davis, CA(-23) Aircraft N8897H piloted by [privacy data omitted] was practicing landings at the uc Davis airport on 5/19/07. At approximately 12:56 hrs PDT, the aircraft landed and the aircraft veered off runway 34R and stopped approximately 60 feet from runway…Incident 20070518016649IRaven S57A · Baltimore, MD(-23) On 5/18/2007, at approximately 8:00 pm, the pilot [privacy data omitted] was in the process of taking his balloon down during a balloon glow at the Baltimore inner harbour when he experienced a strong down draft. The balloon broke loose from one of its…Accident 20070518014759APiper J3C65 · Pontiac, MI(-23) Aircraft N28DR was observed to be partially submerged in Pontiac lake. After the aircraft was towed to shore, a physical inspection of the aircraft revealed that the right wing fore and aft spar were bent at a 45 degree angle. The forward mount of left…Accident 20070518014589ADoug DC931 · Buffalo, NY(-23) On may 18, 2007, at 1320 EST, a northwest airlines, DC-9-31, flight 1411, N1799U experienced a cabin pressurization problem during climb after departing from syracuse hancock international airport, syracuse, NY (syr) to detroit, MI. According to the FAA…Incident 20070518013189IBolkms BK117B2 · St Louis, MO(-23) While repositioning (hovering flight) aircraft at departure location on an authorized flight, the pilot allowed the aircraft to descend and strike the ground hard. Pilot statement reported that that collective lever had slipped out of his hand which…Accident 20070518009909ACessna 150G · Pahrump, NV(-23) Las FSDO inspectors [privacy data omitted] arrived on-scene on the morning of may 18, 2007 to investigate an accident involving a Cessna CE-150-G, N3121J. Earlier that morning, at approximately 8:15 am PST, the pilot took off from the Valley View…Accident 20070518009049ACessna A185F · Renton, WA(-23) Pilot was practicing stop and go landings at airport. On the 4th landing after touch down aircraft made immediate pivot to the right, pilot attempted to compensate using some brake and rudder movement, but was unsuccessful in controlling the aircraft.…Incident 20070518008839IGulstm 114 · Burlington, WA(-23) Pilot/instructor failed to verify that the gear was extended after multiple takeoffs and landings.Accident 20070518008309ACessna 150M · Spanish Fork, UT(-23) Ballooned during landing flare and upon touchdown, the aircraft began rocking uncontrollably. Aircraft departed the left side of runway 30, crossed an unpaved median, taxiway, and hit a small ditch which stopped the aircraft. The right wing was…Accident 20070518006689AUnivar F1 · Morgan, UT(-23) Was high on approach and circled once to the right while descending to land on the freshly mowed Private grass landing strip. Was still in the right turn when the aircraft was caught in a down draft. Full throttle was applied, but the descent could not…Incident 20070517016059IScwzer SA238B · Elmira/Corning, NY(-23)On may 17, 2007 while landing in VMC conditions this experimental aircraft experienced a hard landing. After the first bounce on the runway the pilot performed a go around procedure. On the second landing the aircraft settled on its fixed landing gear…Accident 20070517014449ABeech 95A55 · Dunkirk, NY(-23) [privacy data omitted] on may 17, 2007 at 0940 EDT, a Beechcraft baron, BE-55, registration number c-fdjp, crashed after attempting a missed approach after executing the VOR approach to runway 24 at the Dunkirk airport (kdkk). The pilot of c-fdjp…Accident 20070517008599AMaule MXT7180A · St Petersburg, FL(-23) A/c cleared to land rwy 36, as a/c touched down on rwy gust of wind from 270 moved a/c to the right off the rwy, as a/c approached 60 kt. Another gust of wind blew a/c into seawall where the a/c caught fire and was destroyed. There was a cross wind…Accident 20070517007509ACessna 170B · Fairfield, ID(-23) The aircraft was south of the Fairfield, Idaho airport, and crashed while approaching to land on runway 07. The pilot stated that he was descending from 6000 ft MSL and during the turn to right base, he encountered a wind shear. He lost control of the…Incident 20070516824999ICessna 170B · Dickinson, ND(-23) Single occupant pilot was in landing rollout on runway 32. Pilot states right-hand wheel brake locked up after landing causing aircraft to veer right. Action resulted in a "ground-loop" to the right and coming to rest off the side of the runway.…Incident 20070516014359IPiper PA34220T · Jamestown, NY(-23) On Wednesday, may 16, 2007 at 0945 EST, a Piper aircraft PA-34-220T, s/n 3449351, N1042H, operated by the pilot [privacy data omitted] lost oil pressure in the right engine. Shortly thereafter, the engine lost engine power, and then the engine was…Incident 20070516013529IAmtr CH601XL · Santa Rosa, CA(-23) This incident occurred during flight training under the supervison of a CFI. Student lost control on landing causing the nose gear to break.Accident 20070516010919ACessna 172P · Harrah, OK(-23) On the first landing attempt, the pilot landed left of the center of the runway. Almost immediately on landing, the aircraft's left wing was in contact with vegetation growing on the side of the runway. The aircraft continued veering to the left,…Incident 20070516010639IBuckeye · Mt. Gilead, NCOne or more canopy cords where caught under the left wheel. As the canopy filled with air and lifted off the canopy was distorted on the left side causing the hard left turn and not being able to recover.Incident 20070516010149IBeech 58 · Madison, MS(-23) While departing on runway 35 at Madison airport (mbo) the aircraft struck one of three deer that ran across the runway. The pilot aborted the take-off and returned to the aircraft parking ramp. The aircraft received minor damage on the left side lower…Incident 20070516009809IPiper PA28161 · Tucson, AZ(-23) On may 16, 2007, at Ryan Field, AZ, aircraft N8254J, a Piper PA-28-161, lost control on landing and contacted a runway sign with the left wing leading edge. A student pilot, receiving training at international airline training academy, initially…Incident 20070516008089IPiper PA34200 · Phoenix, AZ(-23) Instructor [privacy data omitted] was instructing both touch and go landings in addition to emergency landing procedures during night time operations with student pilot [privacy data omitted] during final approach and descent onto runway 30 right,…Incident 20070516007319ICessna 172R · Reno, NV(-23) Student pilot doing his first solo touch and go at Reno, NV. After landing the pilot failed to put flaps up and when power was applied he lost control. The aircraft hit two taxiway lights.Incident 20070516006879ISpartn 7W · Columbus, MT(-23) On may 16, 2007, at 1540 mountain daylight time, a spartan-7W aircraft, N17616, registered to redman company, LLC, landed with the landing gear up, I.e. belly-in, at the Columbus, Montana (6S3) airport, while on a pleasure flight. The aircraft's single…Accident 20070516006569AAirtrc AT402A · Edmonson, TX(-23) On may 16, 2007, at 1030 CDT, while spraying a wheat field, aircraft N120CP, AT-402A, was too low and became entangled in the wheat crop and was brought to the ground. The aircraft flipped, ground looped and then rolled on its back. The pilot (sole…Accident 20070515832459ARobsin R22MARINER · Midland, TX(-23) N456PH, a Robinson R-22 mariner, was involved in an unreported crash between April and July of 2007. Aircraft sustained major damage to rotor blades, tail rotor, landing gear skids, and boom was broken. Landowner contacted lubbock FSDO to inquire about…Incident 20070515020339IBeech M35 · Seattle, WA(-23) On 05/15/2007 aircraft N9714R a Beech BE35 was being flown by the pilot [privacy data omitted]. He lined up on runway 31R for landing. The aircraft landed, and then all three gears partially retracted. The aircraft skidded down the runway for…Incident 20070515018249ICessna TR182 · San Antonio, TX(-23) During a solo flight and subsequent landing the pilot [privacy data omitted] experienced failure of the nose gear at the fork assembly. The aircraft incurred damage to the propeller and nose gear. The break in the fork is asymmetric with the right side…Incident 20070515015249IScwzer SGS233A · Endicott, NY(-23) On Tuesday, 5/16/2007 at approximately 1229 local time, the pilot [privacy data omitted] flying N17960, a Schweizer model SGS-2-33A glider, landed on the susquehanna river next to the Tri-Cities Airport. Shortly after take off, while being towed by a…Accident 20070515011369ACessna 150 · English, IN(-23) May 15, 2007 at approximately 11:00 am the pilot [privacy data omitted] was attempting to depart downwind from a grass runway located in English Indiana. Wind was said to be out of the south, less than 10 knots but gusting to 20. The take-off was…Accident 20070515009509AZinair CH2000 · Atwater, CA(-23) On 5/15/2007, at 1315 PDT, zenair CH-2000 aircraft, N363AM, sustained substantial structural damage when it crashed on takeoff from runway 30 at merced macready airport (mce) in merced, CA, during a training flight. Certified flight instructor [privacy…