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 20060701016699IPiper PA32RT300T · Winston Salem, NC(-23) At the conclusion of 2.5 hour cross country flight from hopkinsville, KY, pilot stated that he experienced in-flight electrical failure due to unknown origin soon after contacting greensboro approach. When he lost all communications ability he reversed…Accident 20060701014969ABeech A36 · Somis, CA(-23) On July 1, 2006, N615M departed santa barbara airport at approximately 10:15 am PDT enroute to prescott, AZ. N615M was being operated by a VFR rated private pilot, with his wife, two children, and a dog onboard. N615M was north of filmore at 8,000 ft…Accident 20060701014629ACessna A185E · Clear Lake, MN(-23) N1972U landed short of grass runway at Clear water and flipped over onto top of fuselage damaging prop, cowl, internal and external wing, and tail empennage. Aircraft damage substantial. (-23 amendment) N1972U landed short of grass runway at Clear water…Accident 20060701014239ABeech P35 · Yakutat, AK(-23) N8690M experienced a catastrophic engine failure where the #4 connecting rod separated from the crankshaft and punched through the engine case, causing a loss of power that required an emergency landing on a remote beach. During the roll-out, the nose…Accident 20060701014209ACessna 172H · Ringold, GA(-23) The aircraft took off and made a right turn. While in the right turn the engine sputtered and quit at approximately 50 feet above the trees. No clearing available, the plane struck the trees and ultimately came to rest on the ground inverted. There was…Accident 20060701013999ACessna 172L · Burnet, TX(-23) During instructional flight, the instructor carried a practice emergency landing procedure to within 150 feet of the ground. During recovery, the 15 year old student pilot applied partial power and pitched up, the instructor applied full power and…Accident 20060701013489AAmtr Royalt · Davenport, WA(-23) Experimental amateur built taylor royal t, N2554, was destroyed after colliding with terrain 3/4 mile west of seven bay's airport, Washington. The pilot, who was the registered owner/operator of the airplane, and the two passengers were fatally injured.…Incident 20060701013079IBeech V35B · Bakersfield, CA(-23) Pilot experienced a total electrical failure during gear retraction after departure from sbp. He intended to proceed to destination, but noticed a reduction in cruising speed and decided that the gear was still extended. He elected to land at bfl. Tried…Accident 20060701012569AAmcnlg AL3 · St Augustine, FL(-23) Departed sgj for local flight (steep turns, climbs etc) then returned to sgj for touch & go. On 2nd landing aircraft rolled out to about 15-20 knots & then started turning right. After left rudder & left brake failed to correct the right turn the pilot…Incident 20060701012379IAmrgen AA1A · Lancaster, TX(-23) On 07/01/2006, at 2145 CDT, American aviation aircraft, N531DM, owned by eci-lue incorporated, sustained damage during landing by striking a taxiway marker. VFR conditions prevailed and no flight plan was filed. The aircraft damage was minor and the…Incident 20060701012349ICndair CL6002C10 · Pittsburgh, PA(-23) Aircraft diverted into kpit due to the following: number one engine oil pressure at 24 PSI in flight. The captain shut down engine in flight. The aircraft landed on runway 28L and taxied to the ramp without incident. No evacuation was initiated and no…Accident 20060630026979ABell UH1H · Chicago, IL(-23) Aircraft departed 95th st heliport in response to a reported incident in the proximity of north ave beach @ approximately 41st and the lake. An eyewitness described seeing the tail rotor stop and start again, but intermittently. The aircraft then…Accident 20060630023039ACessna 310D · Sutton, WV(-23) Pilot lost control of aircraft for unknown reasons and drifted left of runway centerline, then continued in a left bank until striking trees. Post impact fire consumed much of wreckage.Accident 20060630022169AAermer FALCOF8L · Montgomery, NY(-23) At 15:39E, N4TB, a flaco F8L, departed from runway 26 at mgj and reported problems with the engine. The aircraft was returning to land on runway 3, when the engine stalled. The pilot landed the aircraft on the grass with unknown damages and minor injury…Incident 20060630015519ICessna 182 · Bloomington-Nor, IL(-23) Pilot was enroute from carbondale, IL (mdh) to rockford, IL (rfd) and was 10 miles north of Bloomington, IL (bmi) on an IFR flight plan, when he noticed that he did not have enough fuel to make rockford. He was cleared to land runway 29 at bmi and…Incident 20060630015339IBeech A35 · Sterling Rockfa, IL(-23) Upon landing at Whiteside county airport, IL (ksqi) pilot lowered the nose and the nose landing gear (NLG) collapsed. The pilot stated gear seemed to be down and lights were green. Investigation revealed corrosion inside the NLG link rod (part number…Accident 20060630013879ABell 206B · Walford, IA(-23) Aircraft departed a parking area in Walford, Iowa for the purpose of filming a procession of automobiles on a state highway. Witnesses stated that the helicopter made several low passes to the east and to the west at a flight path parallel to the…Incident 20060630013769IPiper PA24250 · Long Beach, CA(-23) Excerpts from the pilot interview: the pilot stated that he departed chino, CA enroute to destination, Long Beach, CA. When he was handed off from so cal approach to lgb tower, his altitude was high so he maintained power and lowered the nose for a…Incident 20060630013759IPiper PA23235 · Minden, NV(-23) The pilot reported that while enroute from scottsdale, AZ, to bend, OR, he planned a stop at the Minden tahoe airport for fuel. When approaching to mev on a straight in approach, he lowered the flaps and does not recall lowering the landing gear. The…Accident 20060630013469AHughes 369D · Moab, UT(-23) While engaged in aerial filming at approximately 200 feet AGL the pilot heard a loud bang followed by what he perceived as loss of positive collective control. He entered a power on autorotation to the ground. The aircraft landed hard on uneven terrain.…Accident 20060630013369AMooney M20M · Burnsville, NC(-23) On a teleconference call with [privacy data omitted] and the pilot [privacy data omitted] (PIC), the pilot [privacy data omitted] stated the surface winds reported from ashville approach were 340 degrees at 6 knots. The pilot [privacy data omitted] made…Accident 20060630012469ACessna 180 · Sheridan, WY(-23) Approximately two minutes after a normal take off and climb from runway 23 the pilot reports hearing a loud bang or pop followed by a loss of engine power. An emergency landing was made in a grass field in which the aircraft rolled on its landing gear…Accident 20060629023049ACessna 150H · Smyrna, DE(-23) Upon inspection of the aircraft at the accident scene the condition of the propeller indicates the engine was not producing power at the time when the aircraft impacted trees after having bounced from the adjacent field. On scene examination of the…Incident 20060629022759IBeech V35B · Old Bridge, NJ(-23) Pilot stated that it was very windy when he landed. The pilot's description of bouncing the aircraft more closely resembles porpoising. On the third 'bounce' the nose gear collapsed and the aircraft slid off the right side of the runway and came to rest…Accident 20060629013989APiper PA18150 · Orlando, FL(-23) Loss of control on landing resulted in aircraft going over on its back. [privacy data omitted]Incident 20060629013719IBeech V35 · Oklahoma City, OK(-23) On June 30, 2006 at approximately 2105Z, N3770Q a BE-35 landed on runway 17L at the Wiley Post Airport in bethany, OK. The tower reported that the nose gear collapsed shortly after landing. The pilot and sole occupant was not injured. In a written…Accident 20060629012679AMooney M20M · Searchlight, NV(-23) Pilot stated that the aircraft struck a rock during a normal landing at Searchlight, Nevada airport (IL3) causing the left main landing gear to collapse. The pilot lost directional control of the aircraft.Incident 20060629012409IMooney M20J · Beaumont Port, TX(-23) Aircraft experienced engine failure due to the number four piton rod exiting the engine case. The aircraft landed one mile west of the southeast Texas regional airport (kbpt) in a grass field where the aircraft on rollout struck several fence posts…Accident 20060629012099APiper PA32300 · Midland, TX(-23) On June 29, 2006, at approximately 1154 CDT, N70746, a Piper PA-32-300, departed from Midland airpark (mdd) in Midland, Texas, enroute to baytown, Texas, on a VFR flight. Approximately 14 minutes after take-off, the pilot reported the engine began to…Incident 20060628018009IMtsbsi MU2B35 · Newport, AR(-23) On June 28, 2006, at 1600 central daylight time, a mitsubishi MU23-35 airplane N118P, received minor damage during an emergency landing when the main landing gear would not extend prior to landing at Newport Arkansas. The airplane was registered to and…Incident 20060628015689ICessna 550 · South Bend, IN(-23) Cessna N910MT departed sbn for teb returned to sbn due to pressurization problem. Aircraft landed at sbn at 1122Z, 0622L without incident. Contacted dom requesting a report and ata codes.Incident 20060628014829IBeech 35C33A · Manhattan, KS(-23) The landing gear did not extend and pilot failed to confirm that the landing gear was down before landing. Several mitigating factors were mentioned by the pilot. These factors included looking for other landing traffic, extending downwind for straight…Accident 20060628014679ACessna 170B · Vacaville, CA(-23) After refueling the aircraft, the pilot attempted a downwind take-off. The pilot lost directional control and ground looped the aircraft. The aircraft was substantially damaged, visual meteorological conditions prevailed. The pilot and 3 passengers did…Incident 20060628013749IBac AVRO146RJ85A · Rochester, NY(-23) On June 28, 2006, an avro 146-RJ85A, mesaba airlines flight 3516 during takeoff roll at dtw had a bird strike on #3 engine. Contract maintenance performed the following: visually evaluated #3 engine and found bird matter in gas pitch #3. Visual…Accident 20060628013579ARobsin R44ASTRO · Fresno, CA(-23) The pilot performed a downwind takeoff with a thirteen knot tailwind. During this phase of flight, the helicopter lost tailrotor authority causing loss of control and impacting the ground approximately 200 feet from the initial helicopter takeoff spot.…Accident 20060628013419ABbavia 7AC · Snohomish, WA(-23) During takeoff from Harvey field, rwy 32, the engine began to run rough just after lift off. The pilot executed a left turn and flew parallel to the departing runway. The aircraft never touched down and collided with the airport boundary fence at the…Accident 20060628013359ABell 206B · Chino, CA(-23) Pilot was flying eastbound @ highway 91 (near crosspoint: tollroad 241) when he heard a loud bang. He turned north and landed @ five minutes later on a mesa (960 ft) at the state park, Chino hills, Chino, CA. The pilot exited the aircraft and looked…Accident 20060628011869ACessna 177A · Olympia, WA(-23) On June 28, 2006 the pilot [privacy data omitted] attempted to land N30328, a Cessna 177, at Olympia Airport. The pilot [privacy data omitted] failed to maintain control of the aircraft during the landing which induced oscillations and landed hard on…Accident 20060627021839AAmtr Acrojetspec · Ocean City, MD(-23) A BD5J aircraft flew a low pass over runway 14 at the Ocean City muni airport, pulled up and turned crosswind to fly a normal closed traffic pattern. Witnesses reported that N23AP flew a normal downwind, after turning base leg the aircraft rolled out on…Accident 20060627019219AAmtr THORPT18 · Calaveras, CA(-23) Pilot stated his approach was high and fast. He then landed FAR down the runway, ran off the runway, and the aircraft flipped over.Accident 20060627019049ACessna TU206G · Eldorado, TX(-23) Public use aircraft investigated by homeland security, no other data available.Accident 20060627013949AAmtr ZENITHCH701 · Brussels, WI(-23) Aircraft landing on Private airstrip impacted branches of tree located 100 feet beyond centerline of runway with left wingtip. Aerodynamic effect of impact and minimum continuous airspeed caused aircraft to descend 60 feet to impact point.Accident 20060627013649ABeech 76 · El Cajon, CA(-23) On June 27, 2006, N6720T, a Beech BE-76 aircraft landed runway 27 right, Gillespie field El Cajon. During rollout the left main gear collapsed. The pilot and two passengers were not injured, the aircraft was substantially damaged. Investigation revealed…Accident 20060627013619ACessna T206H · Santa Maria, CA(-23) 06/28/06 @ 10:00, Inspectors [privacy data omitted] from vny FSDO responded to report of hard landing at smx. Located CE-206, N562H at smx jet center. Damage was as follows: 1) propeller has 1 blade broken in hub and the other 2 are q-tipped approx. 6…Accident 20060627012999ACessna 150G · Indianapolis, IN(-23) Pilot/owner elected to "handprop" aircraft after battery depleted during unsuccessful normal start attempt. Tail tie-down ring of aircraft was secured to ramp tie-down anchor with web type cargo strap. Engine started with apparently somewhat greater…Incident 20060627012799ICessna 401B · Naples, FL(-23) On 6/27/2006, pilot with mechanic on board, lost control while taxiing aircraft N7983Q down c taxiway at Naples airport. Aircraft turned left, nose gear collapsed after departing taxiway west of C1 intersection.Accident 20060627012559APiper PA12 · Cooper Landing, AK(-23) [privacy data omitted] was pilot of N7658H a Piper PA-12 on floats which departed anchorage lake hood with [privacy data omitted] as passenger. The flight went south to resurrection pass and devils pass cabin to drop supplies to persons on the ground.…Accident 20060627010529AAmtr RV4 · Arlington, TX(-23) Pilot had a hard landing which she attempted to recover from by adding full power and retracting the flaps. She lost control of the aircraft and departed the west side of runway 34 coming to a stop in a drainage ditch.Accident 20060626022599APiper PA28R200 · Philipsburg, PA(-23) On June 26, 2006 at approximately 0302 am, a Piper PA-28R-200, N56246, was destroyed when it impacted terrain while executing the ILS runway 16 approach at phillipsburg, mid-State airport, Pennsylvania (psb).Accident 20060626019069ACessna 152 · Bennett, CO(-23) The pilot stated that he attempted takeoff with no problem. After he rotated he stated that he lost power and attempted to land in the field at the end of the runway. The aircraft touched down and the front wheel caught in the dirt and the aircradft…