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 20071010824379ICessna 550 · Erie, PA(-23) Aircraft struck a bird during take off and returned to field. Replaced radome.Accident 20071010823819AAmtr Pietenpol · Chanute, KS(-23) On October 10, 2007 at approximately 1815 an amateur built Pietenpol fixed wind aircraft operated by the pilot [privacy data omitted] departed runway 36 (Chanute, KS) to perform a functional flight check for the aircraft owner. On climb out the aircraft…Accident 20071010023749AAmtr RV8A · Corrine, UT(-23) The aircraft lost power while indicating approximately 10 to 12 gallons of fuel on board. The pilot made an off airport landing in a field that had ruts from cattle in the field when it was wet. During roll out the nose wheel dug into a rut and the…Incident 20071010023419IBeech 95B55 · Olathe, KS(-23)Prior to the incident, the pilot, who was in the right seat, and his father, also a rated pilot in the left seat, were practicing a series of takeoffs and landings in N4624A on runway 36 at New Century Aircenter(ixd), Olathe, Kansas. During the landing…Accident 20071010023359AAmtr THORPT18 · Franklin, KY(-23) On Wednesday, October 10, 2007, at approximately 7:00 pm central time, a thorp, T-18, operated by a certificated airline transport pilot, (ATP), was substantially damaged after experiencing loss of directional control while attempting a landing at…Incident 20071010023319IPiper PA31P · Yuma, AZ(-23) Pilot stated that an in-flight fire aft of the right engine, on approach to landing, was first noticed by the flight medic. Emergency procedures followed, and the fire was extinguished within 30 seconds. Aircraft landed without further incident. Landing…Accident 20071010022229APiper PA22 · Townsend, MT(-23) At approximately 10:50 MDT on October 10, 2007, aircraft N1139C, a 1953 PA-22, registered to [privacy data omitted], ground looped at the Townsend, MT airport (K8U8), while engaged in tail wheel landing practice in order for the owner/student to obtain…Incident 20071009832349IBoeing 7272S2F · Indianapolis, IN(-23) According to pilot descrepancy in aircraft logbook, upon descent into ind from mke #2 low oil pressure filter bypass light illuminated followed by oil pressure drop to zero, qrh performed, engine shutdown with oil pressure at 5-10 PSI. Oil quantity…Accident 20071009832149ASnias AS350B2 · Columbus, OH(-23) The aircraft involved in this accident is operated by the Ohio State highway patrol, as a "public use" aircraft, maintained under title 14 CFR, part 91 rules. The following narrative was derived from pilot statements: during a training flight at the…Accident 20071009828169AMooney M20F · Alamo, NV(-23) Aircraft impacted the ground 5 miles north of Alamo, NV, due to loss of oil pressure and engine power at 091244PDT. Substantial damage. The two occupants were not injured. Damage to the aircraft was: left wing had spar damage and skin damage. Prop had…Incident 20071009023639ICambal Z105 · Albuquerque, NM(-23) On October 9, 2007 at 0745 MDT, N867DK, a cameron Z-105 hot air balloon, collided with the envelope of another balloon during a mass ascension at the Albuquerque international balloon fiesta. N867DK had been cleared for takeoff by fiesta launch…Incident 20071009023299IRaven S60A · Albuquerque, NM(-23) On October 9, 2007 at 0915 MDT, N63286, an Aerostar S60A hot air balloon struck a tree during landing approach to a field in Albuquerque, NM with gusty wind conditions. The balloon received minor damage. The pilot and the three passengers were…Incident 20071009022879IBeech A36 · Davis, CA(-23) Pilot stated that he is unsure of what he did, but the nose gear started to collapse as he was taxiing off the runway. He stated that the gear handle was in the up position when he and the mechanic inspected the plane.Accident 20071009022699ASproul 72KTET · Rio Rancho, NM(-23) On October 9, 2007, at approximately 0830 local time, the pilot of N72KX, a Sproul model 72K-TET balloon, serial number S-003, made a hard landing near the intersection of loma vista and high resort in Rio Rancho, new Mexico. The pilot reported that he…Accident 20071009022469AArostr RX8 · Rio Rancho, NM(-23) On October 9, 2007, N5315M, an aero star industries model RX-8 balloon, serial number RX8-3355, made a hard landing in a gulley near boadmoor and high ridge in Rio Rancho, new Mexico. There was a pilot and 2 passengers on board. The pilot was the only…Accident 20071009022279APiper PA31350 · Trinidad, CO(-23) Pilot statement of circumstances of accident say: he failed to select landing gear down on a long final approach to Trinidad, CO. Aircraft landed gear up. Substantial damage incurred. [privacy data omitted]Incident 20071009022169IRaven S60A · Rio Rancho, NM(-23) On October 9, 2007 at 1000 MDT, N2803L, a Raven S-60A hot air balloon, made a hard landing during gusty wind conditions in Rio Rancho, NM. The aircraft was operating under 14 CFR part 91 as a pleasure flight in VFR conditions during the albuquerque…Accident 20071008829819ACessna 150M · Palmyra, PA(-23) Student pilot was landing on rwy 31, CFI recognized student as being high and fast. CFI took over the controls and told the student to follow him through on the controls. CFI touched down half way down the runway (1600 ft length), bounced once and then…Accident 20071008828069ARaven S66A · Albuquerque, NM(-23) On October 8, 2007, at approximately 0742 MDT, an Aerostar S-66A, N7179Z, piloted by a commercial pilot, was substantially damaged when it struck the top wire of a 3-phase powerline. The wire cut through the wicker gondola and became entangled with the…Accident 20071008824659AAmtr Quickie · Merrill, WI(-23) Experimental aircraft. First flight after being in storage for 10 years. Condition inspection performed on 08/20/07. Aircraft destroyed on impact. Pilot indicated he could not get the aircraft to accelerate above 65 mph. Trim could not be adjusted in…Incident 20071008823999IAmtr LANCAIR4P · Dallas, TX(-23) Nose wheel collapsed during landing. Faulty nose wheel pin located.Accident 20071008823809APiper PA28151 · Festus, MO(-23) On October 8, 2007 at approximately 05:45 hrs (local) the pilot [privacy data omitted] departed the williams county airport (kmwa) for a personal flight to the Festus memorial airport (kfes). He was scheduled to arrive at approximately 06:15 hrs…Incident 20071008022839IBeech V35B · Naples, FL(-23) Approximately 30 minutes before landing, aircraft experienced loss of electrical power. PIC attempted to cycle to landing gear down unsuccessfully, then proceeded to lower the gear manually. He stopped once he felt, what he believed was stop resistance.…Accident 20071008022199ACessna T210L · Festus, MO(-23) The pilot [privacy data omitted] stated on October 8, 2007 at approximately 2:00 am local, he was returning to the Festus airport (kfes) from a personal trip. Upon making his approach to land on runway 36, he observed a deer run onto the runway and…Incident 20071007830509IPiper PA28161 · Danielson, CT(-23) The pilot reports that during a right turn into a tie down spot in the parking area, he misjudged his clearance between a fence behind the tie down spot and his left wing tip. The fiberglass wingtip and attached position light assembly were damaged…Accident 20071007829549ABoeing A75N1 · Warrenton, VA(-23) Aircraft departed airfield to the south. Runway slopes upward, tailwind. Pilot failed to clear trees at the south end of runway. Aircraft struck trees and came to rest entangled in power lines. Pilot and passenger egressed from aircraft with minor…Accident 20071007827469ACessna 210C · Columbus, OH(-23) While on approach to newark-heath airport (vta), heath, Ohio on October 7, 2007, the pilot [privacy data omitted] attempted to lower the landing gear when he noticed that the gear would not lock in the down position and the flaps were inoperative also.…Incident 20071007827239ICessna 310J · Texarkana, AR(-23) On October 7, 2007 at 1730 central daylight time, a Cessna 310J airplane received minor damage when it landed with the landing gear up at Texarkana Arkansas. The airplane was registered to the pilot [privacy data omitted] and operated by the pilot…Accident 20071007825309ACessna 170A · Roxboro, NC(-23) I was contacted by atlanta ops center at 11:50AM on 10/07/2007 with the report of an accident that occurred at the Person County Airport (tdf) just south of Roxboro, NC. [privacy data omitted] Of the NTSB and I spoke to the pilot of the aircraft…Accident 20071007825259AChris A1 · San Luis Obisp, CA(-23) The pilot stated he was attempting to land in a field landing strip on a ranch that he frequently used. His landing approach was low, therefore, the main landing gear struck a fence, including some fence posts. After making contact with the ranch…Accident 20071007825249AUnivar 1082 · Indianola, MS(-23) The pilot landed the aircraft on runway 17 at Indianola Municipal Airport (idl) and ground looped the aircraft. The aircraft sustained substantial damage. The right main landing gear folded under the aircraft and the right wing tip struck the ground.…Incident 20071007825099IAmtr KR2 · Goshen, IN(-23) Pilot stated he departed kgwb about 17:30 EST enroute to kgsh. After take-off he climbed to 2500' and cruised straight and level at 90-100 mph for about 20 minutes. As he reached the elkhart county line the engine started running rough for about 10…Incident 20071007825079IAmtr Avidflyer · Grant, MI(-23) When the pilot turned off the auxiliary fuel pump the engine stopped running. The pilot attempted to restart the engine without success. During the ensuing off field landing the landing gear was damaged. Following the incident the engine was found to…Accident 20071007824679AMaule M5220C · Chuathbaluk, AK(-23) Pilot is out of town. Still trying to contact owner. Will update when information becomes available.Accident 20071007824579ADhav DHC2MK1 · King Salmon, AK(-23) On October 10, 2007 a Dehavilland beaver (DHC-2) registered to hartley inc. and piloted by [privacy data omitted] was involved in an aircraft accident near becharof lake Alaska. According to the pilot he flew over the area locally known as bible camp to…Accident 20071007823889ACessna 310N · Ekalaka, MT(-23) The flight departed bozeman, MT (kbzn) at 1002 MDT on an IFR flight plan with the intended destination of baraboo, WI. IMC conditions prevailed for portions of the flight; however, VMC conditions prevailed at the accident site. The pilot communicated,…Incident 20071007023239ICessna 177RG · Grand Canyon, AZ(-23) On 10/07/07, N52878 landed hard on rwy 1 at the Valle, AZ airport (40G) which resulted in the separation of the right main landing wheel and propeller ground strike. There were no injuries sustained by the 2 occupants, the pilot and sole passenger. The…Incident 20071007023189ILBL 240ALBL · Albuquerque, NM(-23) On October 7, 2007 at 0730 MDT, N460LB, a lindstrand 240A hot air balloon, struck a parked trailer during takeoff from balloon fiesta park in Albuquerque, NM, during the Albuquerque international balloon fiesta. The balloon was not damaged and the…Accident 20071007023069ACessna 182P · Portland, OR(-23) The pilot [privacy data omitted] received ATIS information that the winds were 190 at 10 knots before receiving instructions from the Troutdale ATC for a right downwind landing on 07. ATC gave information that there were crosswinds across 07. On final,…Accident 20071007022479AAmtr Glastar · Girdwood, AK(-23) The pilot departed from the lake hood airport for a training flight. The pilot did a takeoff and landing at the birchwood airport before heading to a grass runway near upper lake george. According to the pilot, while on roll out from landing, the pilot…Accident 20071007022439ABeech G35 · Lexington, SC(-23) Pilot stated that while in cruise flight at an altitude of 1600 MSL that the engine started to sputter and then quit. He stated that he switched fuel tanks from the left tank to the aux. And then the right tank with no response. At this time he ran…Accident 20071007022389ACessna 208B · White Pass, WA(-23) This is an interim report. Expect amendments. Investigation delayed because a complete aircraft inspection could not be completed on scene due to extent of damage. Aircraft has been recovered and placed in temporary storage pending all parties from FAA,…Incident 20071007021579IMooney M20B · Hollister, CA(-23) Pilot stated landing gear collapsed on landing. Pilot stated manual landing gear handle (johnson bar) was locked in the down position with a green landing gear down light illuminated.Accident 20071006830579ABbavia 7GCAA · Toughkenamon, PA(-23) While taking off from runway 24 with glider in tow during a glider towing activity at New Garden Airport (N57), the glider instructor noticed a tail wheel shimmy on the tow plane, and the tow plane drifting to the right. The glider instructor aborted…Accident 20071006830249APiper PA28181 · Fan Rock, WV(-23) After landing and while rolling out the left wing of the aircraft came in contact with brush over growing the runway. The contact with the brush caused the pilot to lose directional control of the aircraft resulting in the aircraft leaving the left side…Incident 20071006827769ICessna T210N · Palm Springs, CA(-23) N858BB, piloted by [privacy data omitted] struck a runway sign and runway light during landing at Palm Springs International Airport.Incident 20071006827699IPiper PA28R200 · Jean, NV(-23) The pilot forgot to lower the gear again after an aborted go around and caused prop damage, as well as other minor damage to the aircraft. He had aborted the go around because he lost sight of a departing helicopter.Accident 20071006827192AYaklev YAK50 · San Diego/El C, CA(-23) The pilot [privacy data omitted] was ship no. 3 of a four ship formation flight. He was cleared for and had completed his landing on 27R at Gillespie airport. He maintained visual contact with ships one and two during his landing rollout. He remained on…Accident 20071006827171AYaklev YAK50 · San Diego/El C, CA(-23) The pilot [privacy data omitted] was in aircraft no. 4 of a four ship formation flight. The accident occurred after landing on runway 27R at Gillespie airport during the roll out phase. The pilot [privacy data omitted] was trailing about two thousand…Accident 20071006827119ACessna 150D · Strawberry, AZ(-23) On October 6, 2007, at 1649 mountain standard time, a Cessna 150D, N4570U, collided with rocky terrain during a forced landing near Strawberry, Arizona. The pilot[privacy data omitted] was operating the airplane under the provisions of 14 CFR part 91.…