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.
Incident 20070219006319ISwrngn SA26AT · Crawfordsville, IN(-23) On February 19, 2007 while making an approach to runway 22 at Crawfordsville Municipal Airport aircraft N102DY struck a snow bank off of the displaced runway threshold. Both main landing gear assemblies were separated from the aircraft as a result of…Incident 20070219003279IDiamon DA20C1 · Orlando, FL(-23) Student pilot on final to rwy 7 (orl), wind reported 360 @ 4 kt, prior to touchdown a/c nose turned abruptly to the right, pilot attempted to correct with left rudder, left wing scraped rwy and rotated to right, right gear collapsed under load. A/c…Accident 20070219002619ARobsin R22BETA · Tucson, AZ(-23) N453SH departed the Tucson airport on a training flight. Take off weight was calculated to be 1320 lbs. The flight lasted 30 minutes. Pilot stated: "the maneuver commenced with a 300 foot above ground level left downwind leg with the wing 90 degrees…Incident 20070219002569IAmtr IV1200 · Farmington, AR(-23) On 02/18/2007, N880BW, serial number C96010137, an amateur built aircraft, operated by the pilot [privacy data omitted], a private pilot, experienced a separation of all three propeller blades at 2500' altitude, 5 minutes after takeoff from drake field…Accident 20070219002409ACessna 210K · Lago Vista, TX(-23) During final approach, the aircraft struck terrain one half mile from the airport. Aircraft was destroyed on impact and post fire. Pilot was fatally injured. Aircraft records were destroyed in the fire. No NMAC, no damage to persons or property on the…Incident 20070219002009ICessna 172M · Winnsboro, SC(-23) During a daytime landing on runway 22, the aircraft nosewheel impacted the surface first causing the aircraft to bounce, and then begin porpoising before experiencing a hard landing. The aircraft sustained damage to the nosewheel assembly. The aircraft…Incident 20070219001769IMooney M20E · Factoryville, PA(-23) The pilot stated he was on final approach to runway 04 and felt he needed to conduct a go-around due to excessive airspeed. The pilot stated he made a second approach and never brought the manifold pressure below 12 inches which is the limit at when…Incident 20070218007209IBeech 58P · Aberdeen, SD(-23) On February 18, 2007, N7235K, BE-58-P, took off from Aberdeen, SD. When the pilot retracted the gear, he heard a loud "bang" in the nose area. He noted a red in-transit light. He re-deployed the gear and had two greens for the mains but the nose gear…Incident 20070218004919IAirbus A320212 · Bozeman, MT(-23) On February 18, 2007, northwest airlines flight 1273 was cleared for a full procedure ILS rwy 12 at Bozeman, Montana (bzn) after holding at manni intersection on the approach course. The flight proceeded outbound for approximately 35 nautical miles,…Incident 20070218003889IBeech B36TC · Livermore, CA(-23) Approximately 12 miles out on approach to lv, the plot pitched up to slow the aircraft down and dropped the landing gear which was indicated by three green lights. A few seconds later the pilot noticed the HSI had flagged. He then noticed the alt light…Incident 20070218002819IPiper PA23 · Casa Grande, AZ(-23) After [privacy data omitted] did some practice instrument approaches, he asked [privacy data omitted] if he would like to do a touch and go. [privacy data omitted] Stated he would and took over the controls of the aircraft N2210P. On downwind [privacy…Incident 20070218002439IAmrgen AG5B · San Diego, CA(-23) On 02/18/07, N1193W had completed a landing sdm. The aircraft turned off the active to the taxiway when the right main landing gear assembly separated. The pilot was not injured and the damage to the aircraft was minor. Investigation revealed the axle…Accident 20070218002199AAmtr KB2 · Oklahoma City, OK(-23) Witnesses stated the pilot initially departed runway 17L and completed one circuit around the traffic pattern. While approaching the north end of runway 17L the pilot appeared to hover into the wind and performed several pedal turns. The pilot then…Accident 20070217015181AAmtr Q200 · Livermore, CA(-23) The pilot reported that this was his first flight in the airplane. After liftoff the airplane would not climb, therefore, he decided to land the airplane from an altitude of 4 feet. The landing attempt resulted in a bounced landing. The airplane veered…Accident 20070217013339ALuscom 8A · Compton, CA(-23) The pilot PIC [privacy data omitted] was in the l/h seat of his Luscombe, passenger [privacy data omitted] was in the r/h seat, and both were at the controls during landing. After touchdown on runway 7R, left of centerline in a 7-10 knot wind, the…Incident 20070217006389IBeech B200 · Indianapolis, IN(-23) On February 17, 2007, at approximately 0340 hours, Beechcraft, model BE-200, registration N200EW landed on runway 21 at Eagle Creek airpark (eye). Shortly after touchdown the aircraft departed to the left side of runway approximately 2000 feet from…Accident 20070217004549APiper PA28181 · Poughkeepsie, NY(-23) Aircraft initially came into skyacres airport 44N NY and during landing, aircraft RH MLG struck a snowbank on the edge of the runway. Pilot elected to fly aircraft to kpou due to no arrf at 44N. Pilot was cleared to land rwy 24. Aircraft made normal…Accident 20070217002599AAmcnlg AL11 · Dryden, TX(-23) During take off in gusty winds the pilot lost directional control. The left wing contacted the ground and the aircraft subsequently crashed.Incident 20070217002089IBlanca 14193 · Imperial, CA(-23) The pilot called to report that he performed a partial wheel up landing at Imperial airport. He stated there were two passengers on board. The pilot [privacy data omitted] reported that after takeoff he noticed an abnormality in the gear retraction. He…Incident 20070217002069IAmtr Ctsw · Nampa, ID(-23) A student on a solo flight made a hard landing. The nose gear partially collapsed.Incident 20070217002019ICessna TR182 · Flagstaff, AZ(-23) Aircraft departed runway during landing. Crosswinds of 10 knots gusting to 20. Airman piloted aircraft back onto runway, propeller blades struck runway and taxiway lights, causing dents on prop blades.Incident 20070217001749ICessna 172 · Lewiston, ID(-23) On Saturday February 17 the pilot [privacy data omitted] departed dug bar an unimproved air strip on the snake river. The weather was clear. The pilot [privacy data omitted] stated that the takeoff was normal and at about twenty feet in the air he got…Incident 20070216005339IPiper PA30 · Martinsville, VA(-23) The pilot, with one (1) passenger on board, departed Martinsville, Virginia (mtv) for chapel hill, north carolina. After departure, at approximately 300' AGL, the cabin door opened. The pilot returned to mtv for landing, thinking that the gear had not…Incident 20070216004959IEMB EMB145LR · Middletown, PA(-23) After takeoff, when landing gear lever was selected to the up position, the landing gear remained in the down and locked position. Aircraft returned to MDT and landed without incident. The landing gear control lever was replaced, and subsequent ops and…Accident 20070216002609ACessna 172S · St Louis, MO(-23) The pilot was attempting a landing on rwy 8L at Spirit of saint Louis airport (sus) on 2-16-07 at 1712. The winds were crosswind to the runway at 170 degrees at 12 knots gusting to 18 knots. Upon landing, the pilot failed to maintain directional control…Accident 20070216001829ACessna 340A · Council Bluffs, IA(-23) On February 16, 2007 at 21:04 local time, N111SC, a Cessna 340A aircraft, serial number 340A0335, collided with terrain 4 miles southeast of the Council Bluffs Municipal Airport. The 14 CFR 91 departed northwest Arkansas regional airport with the…Incident 20070215006079IPiper PA28R200 · Atwater, CA(-23) The aircraft experienced a gear malfunction after takeoff, which was the aircraft's first flight after maintenance. The maintenance involved a related gear problem that resulted in replacing some hydraulic components. According to the pilot, the…Incident 20070215005409ICessna 208B · Portland, ME(-23) Pilot was given taxi instructions to active runway. While operating in a non-movement area, the aircraft's propeller came into contact with a runway warning light (2 alternating flashing amber lights) and a taxiway light. Control tower advised pilot of…Incident 20070215004629ILear 35A · Albany, NY(-23) On 02/15/2007, during repositioning flight from kpwm to kcvg, flight crew noticed smoke radiate in the area of the left side tray table in the cabin. Crew then declared an emergency and diverted to kalb. Cvga maintenance traced the problem to a failed…Incident 20070215003849IAgusta A119 · Phoenix, AZ(-23) The pilot CFI [privacy data omitted] of the Phoenix police dept, was giving helicopter flight instruction to fellow police officer [privacy data omitted]. During the flight the CFI was instructing the student in hovering autorotations, after performing…Incident 20070215001979IPiper PA23250 · Miami, FL(-23) During flight from orlando, Florida to opa-Locka, Florida, while descending to land at opf the pilot declared an emergency. He stated that the right main gear had a problem. Miami ATC transferred N144CN to opf west of the airport. Pilot made a low…Accident 20070215001269ACessna 172D · Stephenville, TX(-23) On February 15, 2007 at 1144AM (CST) a CE-172, N2629U, owned and operated by the pilot [privacy data omitted] crashed during final approach to Stephenville airport (ksep) on a VFR flight with VMC weather conditions prevailing. No weather briefing was…Incident 20070214007719IBoeing 717200 · Washington, DC(-23) According to the captain of this flight, the airplane was on approach to runway 1 at dca with reported winds of 310 degrees at 20 knots gusting to 37 knots. Due to the wind condition, a reduced flap setting (25 degrees) and an approach airspeed additive…Incident 20070214004729IIsrael 1124 · Teterboro, NJ(-23) N4WG executed the ILS runway 06 approach with surface wind reported at 310 degrees at 20 knots, gusting to 28 knots. The runway braking action was reported as good by a G-1159 aircraft 30 minutes prior to N4WG landing. The runway conditions for runway…Incident 20070214003869IAmrgen AA5B · Phoenix, AZ(-23) On the morning of February 14th, 2007, the pilot [privacy data omitted] was operating N25ER in the local area of Deer valley airport (kdvt). Upon landing at kdvt, the pilot ^priva^ applied normal braking during his landing rollout on runway 25R. The…Incident 20070214001739IAmtr Zuni · Chino, CA(-23) Experimental aircraft sustained minor damage on initial test flight when nose landing gear collapsed on landing at Chino Airport (cno) on runway 26R. Pilot stated nose gear strut was designed to support four hundred pounds pressure. Pilot is redesigning…Incident 20070214001199ICndair CL6002B19 · Omaha, NE(-23) N8688C, CL-600-2B19, operating as pinnacle airlines flight 5879 was inbound to Omaha, NE, from detroit, MI. The crew declared an emergency due to a flap problem. The crew landed the airplane safely. The crew received a flaps fail message when they…Incident 20070213002489IAmtr LC41550FG · Murrieta, CA(-23) Aircraft in flight could not make right turns. Control side stick would not move from neutral to right. Pilot stated that the ailerons would not move from inside or outside of the aircraft with the engine off and electrical system off. The ailerons…Accident 20070213002189APiper PA18150 · Glennallen, AK(-23) Pilot was departing grizzly lake, about 60 miles nw of Glennallen, AK, in his ski-equipped PA-18. The weather was clear skies and light and variable winds. The lake was the pilot's home base. He was very familiar with the performance requirements to…Incident 20070212831049ICessna 150H · Mesquite, NV(-23) N50368 lost power and made an off-field landing on a highway (I-15) 23 miles nw of Mesquite, NV. There was no damage to the aircraft or injuries to the sole occupant of the aircraft or to people on the surface. PIC stated that the flight originated from…Accident 20070212001969AUrocop EC120B · Pecan Island, LA(-23) On approach to offshore platform, aircraft struck known object in VFR conditions. Aircraft sank and recovered. Upon investigation, all components appeared operational at time of impact.Accident 20070212001889AGrob G109 · Monticello, GA(-23) On February 12, 2007 at 5:00 pm local time aircraft N3875R Grob G-109 attempted to land on runway 28 at (GA06) Monticello airport. The pilot reported weather conditions as clear with slight crosswinds at 10. The pilot stated while attempting a normal…Accident 20070211005519AHughes 369FF · Placida, FL(-23) On February 11, 2007, at 1300 local time, a Hughes 369FF, N819BP, registered to bp aviation, LLC, crashed into the mangroves near 13000 fishery rd, Placida FL, while on a pleasure flight after taking off from the parking lot at the fishery restaurant.…Accident 20070211004459AMaule MXT7180A · Alton Bay, NH(-23) On February 11, 2007, 1345 EST, a wheel equipped Maule, MXT-7-180A, N10438, s/n 21031C, piloted by [privacy data omitted] lost directional control during take off on a frozen lake runway (B18) located in Alton, NH. Approximately 200 feet from the runway…Incident 20070211003399IBbavia 8KCAB · Anchorage, AK(-23) On February 11, 2007, on or about 16:30, the pilot [privacy data omitted] of aircraft N191AC reported engine failure to ATC. He landed at sleepers strip near point mackenzie. Aircraft flipped upon landing. No injuries and minor damage to the aircraft.…Accident 20070211001849APiper PA12 · Elberton, GA(-23) On February 11, 2007 at 4:20 pm local time aircraft N2335M, a Piper PA12 attempted to land on runway 28 at (27A) Elbert county airport. The flight service station reported weather conditions as clear visibility of 10 sm, with winds of 08 KTS at 270…Accident 20070211001219ACessna 172R · Lancaster, TX(-23) Airman rented subject aircraft and took his mother and two of his sister's friends for a local flight around the Lancaster area. After approximately 30 minutes, returned and taxied up to the Lancaster FBO parking area and stopped movement and remained…Accident 20070210016669AAmtr Minimax · Adelanto, CA(-23) Aircraft was "mini-max" homebuit ultralight. No registration numbers. Witnesses stated aircraft was flying level at approximately 200 feet, approximately 60-80 miles per hour. The aircraft started a climb, the right wing dipped, and the aircraft…Incident 20070210009619ICessna 310H · Corona, CA(-23) After experiencing electrical problems, pilot extended landing gear manually. Pilot could not get a safe/unsafe gear indication. Pilot had completed this procedure the week before incident, so he was very familiar with procedure. Pilot landed gear in…Incident 20070210006409ICessna 172S · Minneapolis, MN(-23) Cessna 172S, s/n 172S8226 experienced a sudden, complete, and uncommanded total loss of engine power during the climb out at approximately 400' AGL. Instructor pilot and student crashed into the airport security fence that was 1500' from the end of…